340,926 views
39 votes
39 votes
Excel Question!!!

What is the difference between function and formula in Microsoft Excel? Provide an example of each.

User Andunslg
by
2.6k points

1 Answer

24 votes
24 votes

Answer:

A function is a pre-programmed calculation, whereas a formula is a user-defined calculation. A single function could be used in a formula.

Step-by-step explanation:

if you add =AVERAGE(A1:A56), that is a formula, using the AVERAGE function. If you enter =SUM(G4+A5) - 25 * MIN(B3:B6), that is a formula which uses both the SUM function and the MIN function, as well as standard mathematical operators (-, +, *).

User Blueman
by
2.7k points