How to Enter Functions in Excel: Step-by-Step

Updated 14 November 2026 · Standard formula, shown below

This guide shows you how to type functions into Excel—the built-in formulas that calculate everything from sums to complex lookups. You’ll learn the correct syntax, how to use the Function Library and Formula Bar, and how to avoid common errors. No prior experience is needed, just a spreadsheet with some data.

What You’ll Need

A computer with Microsoft Excel (2016 or later, or Excel for Microsoft 365) or a free alternative like Google Sheets (steps are nearly identical).
A spreadsheet with at least a few cells containing numbers or text you want to work with.
Basic familiarity with clicking and typing in Excel cells.

Step-by-Step

Select the cell where you want the result to appear. Click any empty cell, for example, B2.
Type an equals sign (=). Every function in Excel must start with =. This tells Excel that what follows is a formula, not text.
Start typing the function name. For instance, type =SUM. As you type, Excel shows a drop-down list of matching functions. You can double-click the one you want or keep typing.
Add an opening parenthesis after the function name: =SUM(. Excel will show a tooltip describing the arguments (inputs) the function expects.
Enter the arguments. These are the values, cell references, or ranges the function will use. For SUM, you might type A1:A10 to sum all numbers in cells A1 through A10. Separate multiple arguments with commas, e.g., =SUM(A1, B1, C1).
Close the parenthesis and press Enter. Excel calculates the result and displays it in the selected cell. The formula itself remains visible in the Formula Bar when you click the cell.
Use the Function Library (optional). Click the Formulas tab on the ribbon, then choose a category like “AutoSum” or “Logical”. Pick a function from the list, and Excel inserts the function name and an opening parenthesis for you. Then you just fill in the arguments.
Use the Insert Function dialog (optional). Click the fx button next to the Formula Bar. Search for a function by name or browse by category. Select it and click OK. A dialog box appears with fields for each argument—fill them in and click OK.
Nest functions (if needed). You can use a function as an argument inside another function. For example, =IF(SUM(A1:A10)>100, "High", "Low"). Type the inner function where you would normally type a value.

Common Mistakes

Forgetting the equals sign: Typing SUM(A1:A10) without the = treats it as text. Always start with =.
Using the wrong argument separator: In some regions, Excel uses a semicolon (;) instead of a comma (,). Check your system’s list separator in Windows Regional Settings.
Mismatched parentheses: Every opening parenthesis needs a closing one. Excel usually warns you, but it’s easy to miss when nesting functions.
Referencing the wrong range: Double-check that your range (like A1:A10) includes all the cells you intend. A common error is including the header row, which can cause text to be ignored or produce a #VALUE! error.
Using text in numeric functions: Functions like SUM ignore text, but others like AVERAGE will return a #VALUE! error if a referenced cell contains non-numeric text.

Tips

Use the Formula Bar: Click any cell with a formula, and you’ll see the full formula in the Formula Bar. You can edit it there directly.
Press F2 to edit the formula in the cell itself. This is faster than clicking the Formula Bar.
Use named ranges: Instead of typing =SUM(A1:A10), you can name that range “Sales” and type =SUM(Sales). This makes formulas easier to read.
Take advantage of AutoSum: For SUM, AVERAGE, COUNT, MAX, and MIN, select the cell below or to the right of your data and press Alt + = (Windows) or Command + Shift + T (Mac). Excel guesses the range.
Use the function tooltip: When you type a function, a small tooltip shows the argument names. Click on an argument name in the tooltip to select it in the formula.
Test with simple data: Before applying a complex function to your real data, try it on a few known values to verify it works.

Troubleshooting

#NAME? error: This usually means you misspelled the function name or forgot the equals sign. Check the spelling and that the function starts with =.
#VALUE! error: The function received the wrong type of argument—for example, text where a number is expected. Check your cell references and make sure they point to numeric cells.
#REF! error: A referenced cell was deleted or the formula was copied to a location where the reference no longer exists. Undo the deletion (Ctrl+Z) or fix the range.
#DIV/0! error: You’re dividing by zero or an empty cell. Check the divisor and ensure it’s not blank or zero.
Function not appearing in the drop-down: If you type =SU and see no suggestions, your Excel may have AutoComplete disabled. Go to File > Options > Advanced and check “Enable AutoComplete for cell values and formulas”.
The result is wrong but no error: Check the order of operations. Excel follows standard math precedence (parentheses, exponents, multiplication/division, addition/subtraction). Use parentheses to make your intent explicit.

Frequently Asked Questions

Do I need to type the function name in uppercase?

No. Excel is not case-sensitive for function names. =sum(A1:A10) works the same as =SUM(A1:A10).

Can I enter a function without typing the equals sign?

No. The equals sign is required to tell Excel that the cell contains a formula. Without it, Excel treats the text as a string.

How do I enter a function that uses a range from another sheet?

Type the sheet name followed by an exclamation mark and the range, like =SUM(Sheet2!A1:A10). If the sheet name contains spaces, enclose it in single quotes: =SUM('My Sheet'!A1:A10).

What’s the difference between a function and a formula?

A formula is any expression that starts with =, like =A1+B1. A function is a predefined formula, like =SUM(A1:B1). All functions are formulas, but not all formulas use functions.

Can I use a function in a cell that already has text?

No. A cell can contain either a value (text, number) or a formula, but not both. If you type a formula in a cell with text, it will replace the text.

Why does Excel show the formula as text instead of calculating?

This usually happens if the cell is formatted as Text. Select the cell, go to the Home tab, and change the number format to General. Then re-enter the formula by pressing F2 and Enter.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.