Excel does math when you write a formula, not when you type a number

A formula in Excel starts with an equals sign and tells the program to calculate something instead of just storing the text you typed. If you type 500 in a cell, Excel treats it as a number you want to keep. If you type =500+200, Excel calculates the result and shows 700. The equals sign is what makes Excel do the work — without it, you are just typing.

The simplest formulas add, subtract, multiply, or divide. You can also reference cells instead of typing numbers directly, which means when you change a number, the calculation updates automatically. This is the core reason people use Excel instead of a calculator: one number changes, and every formula that depends on it recalculates when ready.

You do not need to memorize syntax or learn programming. You need to understand that formulas are instructions, and Excel follows them in a predictable order. Once you write your first few formulas, the pattern becomes obvious.

Key Takeaways

  • Every formula starts with an equals sign, followed by the calculation you want — for example, =A1+B1 adds the numbers in cells A1 and B1.
  • You can reference cells by their column letter and row number, so if you change the number in a cell, any formula using that cell recalculates automatically.
  • The four basic operations are + (add), - (subtract), * (multiply), and / (divide), and Excel follows standard math order — multiplication and division before addition and subtraction.
  • Parentheses force Excel to calculate what is inside them first, so =(A1+B1)*C1 adds A1 and B1 before multiplying by C1.
  • You can copy a formula down a column or across a row, and Excel automatically adjusts the cell references for each new row or column.

How to write your first formula

Click the cell where you want the result to appear. Type an equals sign to start the formula. Then type the calculation using cell references — the column letter and row number of the cells you want to use. For example, if you have a price in cell A2 and a quantity in cell B2, type =A2*B2 to multiply them. Press Enter, and Excel shows the result.

The cell reference tells Excel which number to use. If you type =A2*B2 in cell C2, Excel looks at whatever number is in A2, multiplies it by whatever is in B2, and displays the answer in C2. If you later change the number in A2, the result in C2 updates automatically without you retyping anything.

You can also type numbers directly into a formula. =500*1.1 multiplies 500 by 1.1 and shows 550. But using cell references is more powerful because it lets you change the inputs and see the result update when ready.

Using the four basic operations and parentheses

Excel uses + to add, - to subtract, * to multiply, and / to divide. You can combine them in one formula: =A1+B1*C1 adds A1 to the result of B1 times C1, because Excel does multiplication before addition. This is the same order you learned in school — multiplication and division happen first, then addition and subtraction from left to right.

If you want to change that order, use parentheses. =(A1+B1)*C1 adds A1 and B1 first, then multiplies the result by C1. Excel always calculates what is inside parentheses before anything outside them. You can nest parentheses too: =((A1+B1)*C1)/D1 adds A1 and B1, multiplies by C1, then divides by D1.

A common mistake is forgetting parentheses when you need them. If you want to calculate a 10 percent tip on a bill that includes tax, you need =(A1+B1)*0.1, not =A1+B1*0.1, because the second formula multiplies only B1 by 0.1, then adds A1.

Copying formulas down columns and across rows

Once you write a formula in one cell, you can copy it to other cells and Excel adjusts the references automatically. If you write =A2*B2 in cell C2 and copy it down to C3, Excel changes it to =A3*B3. The column stays the same (C), but the row numbers shift to match where you pasted it.

To copy a formula, click the cell containing it, then click and drag the small square in the bottom right corner of the cell down or across to the cells where you want the formula to go. Excel fills in the formula and adjusts the cell references for each row or column. This saves you from typing the same formula dozens of times.

Sometimes you want a reference to stay the same when you copy. Use a dollar sign before the column letter or row number to lock it. =$A$2*B2 keeps A2 the same no matter where you copy it, but B2 changes to B3, B4, and so on. =A$2*B2 locks only the row, so the column changes but the row stays 2. This is useful when you have a fixed value (like a tax rate) that should not change when you copy the formula.

Common functions that do calculations for you

Excel has built-in functions that perform common calculations without you typing the full formula. SUM adds a range of cells, AVERAGE finds the middle value, COUNT counts how many cells have numbers, and MAX and MIN find the highest and lowest values. You type the function name, then the cells in parentheses: =SUM(A1:A10) adds all numbers from A1 to A10.

The colon between two cell references means "from this cell to that cell". =SUM(A1:A10) is much faster than typing =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10. If you add a new row of data between A1 and A10, the SUM formula automatically includes it.

Other useful functions include ROUND to round a number to a certain number of decimal places, IF to show different results based on a condition, and CONCATENATE to combine text from multiple cells. You do not need to memorize these — when you need one, you can search for it or use Excel's function wizard, which guides you through the syntax.

Checking your formula for errors

If a formula shows an error like #DIV/0!, #REF!, or #NAME?, Excel is telling you something is wrong. #DIV/0! means you tried to divide by zero or by an empty cell. #REF! means the formula refers to a cell that no longer exists — usually because you deleted a column or row. #NAME? means you misspelled a function name or used a cell reference that does not exist.

The easiest way to fix an error is to click the cell with the error and look at the formula bar at the top of the screen. You can see exactly what the formula says and spot the problem. Check that all cell references point to the right cells, that you did not delete anything the formula depends on, and that function names are spelled correctly.

If a formula shows a number that looks wrong, the formula itself might be correct but your logic might not be. Double-check the order of operations — remember that multiplication and division happen before addition and subtraction unless you use parentheses. Trace through the formula step by step and verify that each cell reference points to the number you think it does.

When to use formulas instead of typing numbers

Use a formula whenever the result depends on other numbers that might change. If you are calculating a total, a percentage, a discount, or anything that comes from other cells, write a formula. If a number is fixed and will never change, you can type it directly. But in practice, most numbers in a spreadsheet change eventually, so formulas are usually the safer choice.

Formulas also make your spreadsheet easier to audit and fix. If someone asks where a number came from, you can click the cell and see the formula. If you need to change how something is calculated, you change the formula once and every result that depends on it updates automatically. If you typed all the numbers manually, you would have to find and change each one.

A spreadsheet with formulas is also less prone to human error. You type the formula once, copy it to other cells, and Excel does the math. You type a number manually, and you might make a typo or forget to update it later.

Frequently Asked Questions

What does the colon mean in a formula like =SUM(A1:A10)?

The colon means "from this cell to that cell". =SUM(A1:A10) adds every cell from A1 through A10. You can use a colon in any formula to refer to a range of cells instead of typing each one individually. =AVERAGE(B5:B20) finds the average of all cells from B5 to B20.

Can I use a formula to calculate something based on a condition?

Yes, using the IF function. =IF(A1>100,"Over budget","Within budget") checks if A1 is greater than 100 and shows one message if true, another if false. You can nest multiple IF statements or combine them with other functions to handle more complex conditions.

What happens if I copy a formula and the cell references change in a way I do not want?

Use a dollar sign to lock the reference. =$A$1 never changes when you copy it. =A$1 locks only the row, so the column changes. =$A1 locks only the column, so the row changes. This is useful when you have a fixed value like a tax rate that should stay the same in every copy of the formula.

Can I see what cells a formula is using?

Click the cell with the formula and look at the formula bar at the top. You can see the entire formula written out. If you want to see which cells are referenced, click in the formula bar and Excel highlights them with colored boxes. This helps you verify that the formula is using the right cells.

What is the difference between = and ==?

In Excel, use a single equals sign = to start a formula. A double equals sign == does not work in Excel. If you are comparing two values to see if they are equal, use =IF(A1=B1,"Match","No match") with a single equals sign inside the IF function.