What a formula does and how to start one

An Excel formula is an instruction that tells a cell to calculate something instead of just holding text or a number. When you type a formula, Excel reads it, does the math or comparison you asked for, and shows you the result in that cell. Every formula starts with an equals sign — that single character tells Excel "this is a formula, not just data".

To start writing a formula, click the cell where you want the answer to appear. Type the equals sign. Then type the rest of your formula. When you press Enter, Excel calculates it and shows the result. The formula itself stays in the cell — if you click the cell again, you'll see the formula in the formula bar at the top of the screen, not the answer.

Key Takeaways

  • Every formula starts with an equals sign, which tells Excel to calculate instead of storing text.
  • The most common formulas use basic math operators: + for addition, - for subtraction, * for multiplication, and / for division.
  • You can point and click on cells instead of typing their addresses, which is faster and less error-prone than typing them by hand.
  • Built-in functions like SUM, AVERAGE, and COUNT do common calculations automatically without you having to write the math yourself.
  • When you copy a formula down to other cells, Excel automatically adjusts the cell references so each row calculates its own data.

Basic math formulas with operators

The simplest formulas use the four basic math operators. If you have a price in cell A1 and a quantity in cell B1, you can multiply them by typing =A1*B1 in a new cell. Excel will multiply whatever number is in A1 by whatever is in B1 and show you the result. The asterisk means multiply; use a forward slash (/) for division, a plus sign (+) for addition, and a minus sign (-) for subtraction.

You can also mix operators in one formula. If you want to add three cells and then divide by 2, you would type =SUM(A1:A3)/2 or =(A1+A2+A3)/2. Excel follows the standard order of operations — it does multiplication and division before addition and subtraction, unless you use parentheses to change the order. Parentheses always go first, so if you want to add two numbers and then multiply the result, put the addition inside parentheses.

Using cell references instead of typing numbers

Instead of typing the actual numbers into your formula, use the cell address where that number lives. If your price is in A1, type A1 in the formula instead of typing the price itself. This matters because if the price changes later, the formula automatically recalculates with the new number. If you had typed the number directly, you would have to edit the formula by hand.

The fastest way to add a cell reference is to click on the cell instead of typing its address. Click in the cell where you want your formula. Type the equals sign and the operator (like +). Then click on the cell you want to reference — Excel will type its address for you. Keep clicking cells and typing operators until your formula is complete, then press Enter. This method is much faster than typing A1, B2, C5 by hand, and you won't mistype a cell address.

SUM, AVERAGE, COUNT, and other built-in functions

Excel has built-in functions that do common calculations without you having to write the math. SUM adds up a range of cells. If you have numbers in cells A1 through A10, you can type =SUM(A1:A10) and Excel will add all ten numbers for you. The colon between A1 and A10 means "from A1 to A10, including everything in between".

AVERAGE finds the middle value of a range. Type =AVERAGE(A1:A10) to find the average of those ten cells. COUNT tells you how many cells in a range hold numbers (not text or blank cells). MAX finds the largest number in a range, and MIN finds the smallest. All of these work the same way: type the function name, then put the range in parentheses.

You can also use functions on cells that are not next to each other. If you want to add A1, A5, and A10 but skip the cells in between, type =SUM(A1,A5,A10) with commas separating each cell or range. This is useful when your data is scattered across the spreadsheet.

Copying formulas to other rows and columns

Once you write a formula in one cell, you can copy it down to other cells and Excel will adjust the references automatically. If you write =A1*B1 in cell C1, then copy that formula down to C2, Excel changes it to =A2*B2. Each row calculates its own data. This is called a relative reference — the formula adjusts based on where you paste it.

To copy a formula, click the cell that holds it. Look for the small square in the bottom-right corner of the cell (called the fill handle). Click and drag that square down as far as you need. Excel will copy the formula to each cell and adjust the row numbers automatically. Alternatively, you can copy the cell (Ctrl+C on Windows, Command+C on Mac), select the range where you want it, and paste (Ctrl+V or Command+V).

If you want a cell reference to stay the same when you copy the formula, use a dollar sign. Type =$A$1*B1 and the A1 part will never change when you copy it down, but B1 will adjust to B2, B3, and so on. This is called an absolute reference and is useful when one number should apply to all your calculations.

Common mistakes and how to fix them

The most common mistake is forgetting the equals sign. If you type A1+B1 without the equals sign, Excel treats it as text, not a formula. The cell will show the text "A1+B1" instead of calculating. Always start with =.

Another frequent error is using the wrong operator. A forward slash (/) means divide, but a backslash (\) does not work in formulas. If your formula is not calculating correctly, check that you used * for multiply and / for divide. Also watch for spaces — =A1 + B1 and =A1+B1 both work, but extra spaces can sometimes cause confusion when you are reading the formula later.

If a cell shows #NAME? or #VALUE!, the formula has a syntax error — something is spelled wrong or structured incorrectly. Click the cell and look at the formula bar. Check that function names are spelled correctly (SUM not SUMM, AVERAGE not AVERGE) and that parentheses are balanced — every opening parenthesis needs a closing one.

When to use formulas instead of just typing the answer

Use a formula whenever the answer depends on other cells. If you have a list of prices and you need the total, use SUM instead of adding them by hand and typing the result. The moment one price changes, the total updates automatically. If you type the total by hand, you have to remember to recalculate it.

Formulas also catch your own math mistakes. If you add five numbers by hand and get the wrong answer, nobody will know. If you use SUM, Excel does the math for you and you can trust the result. For a one-time calculation where the numbers will never change, typing the answer is fine. For anything that might change, or anything you might need to check later, use a formula.

Frequently Asked Questions

What does the colon mean in a formula like A1:A10?

The colon means "from A1 to A10, including all cells in between". It is a shorthand for listing a range. You use it in functions like SUM, AVERAGE, and COUNT. If you want to add only A1, A5, and A10 without the cells in between, use commas instead: SUM(A1,A5,A10).

Can I use a formula to compare numbers, like checking if one is bigger than another?

Yes. Type =A1>B1 to check if A1 is bigger than B1. Excel will show TRUE or FALSE. You can also use < (less than), = (equal to), >= (greater than or equal to), and <= (less than or equal to). This is useful for conditional formatting or for creating IF statements that do different things based on the comparison.

Why does my formula show the formula itself instead of the answer?

The cell is probably formatted as text. Right-click the cell, choose Format Cells, and change the format to Number or General. Then edit the formula (press F2 or double-click the cell) and press Enter again. Excel will calculate it this time.

Can I use a formula to pull data from a different sheet?

Yes. Type the sheet name, then an exclamation point, then the cell address. For example, =Sheet2!A1 will pull the value from cell A1 on Sheet2. If the sheet name has a space, put it in single quotes: ='Sheet 2'!A1.

What is the difference between copying a formula and dragging the fill handle?

Both do the same thing — they copy the formula to other cells and adjust the references. Dragging the fill handle is faster if you are copying to nearby cells. Copying and pasting is better if you are copying to cells far away or to a different part of the spreadsheet.