How to Use Excel Formulas for Beginners

Step by step

1. Start every formula with an equals sign

   Click any cell and type = to begin a formula. Excel recognizes the equals sign as the start of a calculation. Without it, Excel treats your entry as plain text. Type =5+3 and press Enter to see Excel calculate the result.

   Note: Press Escape to cancel a formula you're typing without saving changes to the cell.

2. Reference cells instead of typing numbers

   Click cell A1, type 10, then press Enter. Click cell A2, type 5, then press Enter. In cell A3, type =A1+A2 and press Enter. Excel adds the values from cells A1 and A2. When you change the number in A1 or A2, A3 updates automatically.

   Note: Click and drag to select multiple cells when building formulas instead of typing each cell reference.

3. Use the SUM function to add multiple cells

   Enter numbers in cells A1 through A5. Click cell A6 and type =SUM(A1:A5), then press Enter. Excel adds all values in the range. The colon creates a range from the first cell to the last cell. SUM works with any range size.

   Note: Type =SUM( then select your range with the mouse to avoid typing errors in cell references.

4. Calculate averages with the AVERAGE function

   Using the same data from step 3, click cell A7 and type =AVERAGE(A1:A5), then press Enter. Excel calculates the mean of all values in the range. AVERAGE ignores empty cells but includes cells containing zero.

   Note: Use AVERAGEA to include text and logical values in your calculation, or AVERAGEIF to average only cells meeting specific criteria.

5. Create conditional logic with IF functions

   Click cell B1, type =IF(A1>10,"High","Low") and press Enter. This formula checks if A1 contains a value greater than 10. If true, it displays "High". If false, it displays "Low". Change the value in A1 to see the result update.

   Note: Nest multiple IF functions like =IF(A1>20,"Very High",IF(A1>10,"High","Low")) to create multiple conditions.

6. Copy formulas to multiple cells

   Select the cell containing your formula. Press Ctrl+C to copy. Select the range where you want the formula applied. Press Ctrl+V to paste. Excel automatically adjusts cell references for each row or column. A formula referencing A1 becomes A2 when copied down one row.

   Note: Use $ signs like $A$1 to create absolute references that don't change when copied to other cells.

7. Check your formulas in the formula bar

   Click any cell containing a formula. The formula bar above the spreadsheet shows the actual formula while the cell displays the result. Use the formula bar to edit formulas without retyping them completely. Press F2 to edit a formula directly in the cell.

   Note: Press Ctrl+` (grave accent) to toggle between showing formulas and showing results across your entire worksheet.

8. Fix common formula errors

   Excel displays #DIV/0! when dividing by zero, #VALUE! for wrong data types, and #REF! for invalid cell references. Click the error cell to see Excel's suggested fixes. Double-check parentheses, cell references, and function spelling to resolve most errors.

   Note: Use the IFERROR function like =IFERROR(A1/B1,0) to replace error messages with custom values or blank cells.