1.

What Is The Difference Between A Function And A Formula In Excel?

Answer»

A formula is a user-defined expression that calculates a value. A function is pre-defined built-in OPERATION that can TAKE the SPECIFIED number of ARGUMENTS. A user can create formulas that can be complex and can have multiple functions in it.

For example, =A1+A2 is a formula and =SUM (A1:A10) is a function.

A formula is a user-defined expression that calculates a value. A function is pre-defined built-in operation that can take the specified number of arguments. A user can create formulas that can be complex and can have multiple functions in it.

For example, =A1+A2 is a formula and =SUM (A1:A10) is a function.



Discussion

No Comment Found