Question

difference between formula and function

Answer 1

Answer:

A formula is something that the user defines, and can use/refer to various functions in it. They are similar in that both return a result based on the calculations that each performs. The difference is that a function is a built-in calculation, while a formula is a user-defined calculation.

Answer 2

Explanation:

Formulas can be as simple or as complex as the user wants.

A formula can contain values, references to cells, defined names, and functions. A function is a piece of code designed to calculate specific values and are used inside formulas.