Create a formula by using a function

You can create a formula to calculate values in your worksheet by using a function. For example, the formulas =SUM(A1:A2) and SUM(A1,A2) both use the SUM function to add the values in cells A1 and A2. Formulas always start with an equal sign (=).

  1. Click the cell where you want the formula.

  2. To start the formula with the function, click in the formula bar Button image or start typing the formula in the cell.

    Tip:  For a list of available functions, see functions (alphabetical) or functions (by category).

  3. After you complete the arguments for the formula, press Enter to see the formula result in the cell.

Tip:  If you frequently use functions, you can enter your formulas directly on the worksheet. After you type the equal sign (=) and the function name, you can see information about the formula syntax and the function arguments.


Use the data here to work with examples of formulas using a function. You can see and change formulas, and enter your own formulas.

Copy the table to cell A1 in a blank worksheet to work with these examples of formulas that use functions.














Adds all numbers in column A



Averages all numbers in the range A1:B4


Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.