Function

An Excel function is a pre-built formula with a specific purpose.

Most Excel functions require specific inputs, calledfunction arguments.

Formulas vs Functions

When you use a function in Excel, you are using a formula.

So, by definition, all functions are formulas.

However, it’s possible for you to create formulas in Excel without any functions at all.

For example, this formula returns the sum of A1 and A2 without any functions.