A formula in Excel starts with an equals sign and tells the spreadsheet to do math or look up data

When you type =2+2 into a cell and press Enter, Excel shows you 4. That equals sign is what makes Excel treat your input as a formula instead of text. Without it, Excel would just store the characters you typed. With it, Excel reads the instruction, does the work, and displays the result.

Formulas can be as straightforward as adding two numbers or as complex as finding the average of hundreds of cells, looking up a value in another table, or checking whether a condition is true. The formula itself stays hidden once you press Enter — you see only the answer. If you click on that cell later, the formula bar at the top shows you what calculation produced that answer.

Most formulas use cell references instead of typing numbers directly. If you type =A1+A2, Excel adds whatever numbers are in cells A1 and A2. If you change the number in A1 later, the formula automatically recalculates. This is what makes spreadsheets powerful for budgets, inventories, grade tracking, or any situation where numbers change and you need totals to update on their own.

Key Takeaways

  • Every formula starts with an equals sign, followed by cell references (like A1), operators (like +, -, *, /), or function names (like SUM or AVERAGE).
  • Cell references let you build formulas that update automatically when the numbers in those cells change.
  • Common functions like SUM, AVERAGE, COUNT, and IF handle most everyday spreadsheet tasks without you needing to write complex math.
  • Copying a formula down a column automatically adjusts the cell references so each row calculates its own data.
  • Parentheses control the order of operations, just like in math class — Excel solves what is inside parentheses first.

The basic building blocks: operators and cell references

A formula uses operators to tell Excel what to do. The four basic ones are + (add), - (subtract), * (multiply), and / (divide). If you have a price in cell A1 and a quantity in cell B1, you can type =A1*B1 to get the total cost. Excel multiplies whatever is in A1 by whatever is in B1.

Cell references are the letter-and-number labels you see on the spreadsheet grid. Columns are letters (A, B, C, and so on). Rows are numbers (1, 2, 3, and so on). Cell A1 is the intersection of column A and row 1. When you type a formula that refers to A1, you are telling Excel to use the value stored in that specific cell.

You can also refer to a range of cells at once. =SUM(A1:A10) adds all the numbers from A1 through A10. The colon means "through" — it includes every cell in that span. This saves you from typing =A1+A2+A3+A4+A5+A6+A7+A8+A9+A10, which is tedious and straightforward to get wrong.

Common functions that handle most everyday tasks

A function is a pre-built formula that Excel already knows how to do. You type the function name, then put your data inside parentheses. SUM adds numbers. AVERAGE finds the middle value. COUNT tells you how many cells contain numbers. MAX finds the largest number in a range, and MIN finds the smallest.

If you have a list of test scores in cells A1 through A20, you can type =AVERAGE(A1:A20) to get the average score. You do not have to add them all up and divide by 20 yourself — Excel does it. If you add a new score to A21 later, you can update the formula to =AVERAGE(A1:A21) and it recalculates when ready.

The IF function lets you make decisions. =IF(A1>100,"Over budget","OK") checks whether the number in A1 is greater than 100. If it is, the cell displays "Over budget". If it is not, the cell displays "OK". This is useful for flagging problems, calculating bonuses based on thresholds, or showing different messages depending on what the data says.

How to write and enter a formula

Click on the cell where you want the answer to appear. Type the equals sign first — this tells Excel you are writing a formula, not just typing text. Then type your formula. You can type cell references by hand, or you can click on cells while you are typing and Excel will insert their references for you.

For example, to add two numbers: click on an empty cell, type =, click on the cell with the first number, type +, click on the cell with the second number, then press Enter. Excel shows the sum. The formula bar shows what you typed.

If you make a mistake, press Escape before you hit Enter, and your typing disappears without being saved. If you already pressed Enter and want to fix it, click on the cell and look at the formula bar — you can edit the formula there, or double-click the cell to edit it directly in the cell itself.

Copying formulas down a column so each row calculates its own data

Once you write a formula in one cell, you can copy it to other cells and Excel adjusts the references automatically. If you write =A1+B1 in cell C1, then copy that formula down to C2, Excel changes it to =A2+B2. The pattern stays the same, but the row numbers shift.

To copy a formula down: click on the cell with the formula, then 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 copies the formula to each cell and adjusts the references. 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).

This is why spreadsheets are faster than a calculator for repetitive work. Write the formula once, copy it down to 100 rows, and all 100 rows calculate at once. If the source data changes, all 100 answers update when ready.

Using parentheses to control what Excel calculates first

Excel follows the standard order of operations from math: multiplication and division before addition and subtraction. If you type =2+3*4, Excel calculates 3*4 first (which is 12), then adds 2, giving you 14. It does not add 2+3 first.

If you want Excel to add first, use parentheses: =(2+3)*4 gives you 20. Excel always solves what is inside parentheses before anything else. This matters in real spreadsheets — if you are calculating a discount on a total, you need to make sure Excel adds up the subtotal before explore the percentage.

For example, =A1*0.9 multiplies A1 by 0.9 (a 10% discount). But =(A1+A2)*0.9 adds A1 and A2 first, then applies the discount to the total. Without the parentheses, you would discount only A1 and leave A2 full price.

Fixing formulas when they show an error or the wrong answer

If a cell shows #DIV/0!, you tried to divide by zero — either a cell you referenced is empty, or it contains a zero. #REF! means you deleted a cell that the formula was pointing to. #NAME? means you misspelled a function name or used a cell reference that does not exist. Click on the cell, look at the formula bar, and check your spelling and your cell references.

If the formula calculates but the answer looks wrong, check whether you are using the right cell references. A common mistake is writing =SUM(A1:A10) when you meant =SUM(B1:B10) — the formula works perfectly, but it is adding the wrong column. Click on the cell and trace which cells the formula is actually using.

Another common issue: if you copy a formula and the references do not adjust the way you expected, you may need to use an absolute reference. Type a dollar sign before the letter and number — $A$1 — and that reference will not change when you copy the formula. This is useful when one cell should always be used (like a tax rate or a conversion factor) while other references shift with each row.

Frequently Asked Questions

What is the difference between a formula and a function?

A formula is any instruction that starts with an equals sign — it can be as straightforward as =2+2. A function is a named operation that Excel already knows how to do, like SUM or AVERAGE. Functions are a type of formula, but not all formulas are functions. You can write a formula using operators alone, or you can use a function inside a formula.

Can I use a formula that refers to cells in a different sheet?

Yes. Type the sheet name, then an exclamation point, then the cell reference. For example, =Sheet2!A1+Sheet2!B1 adds a cell from Sheet2 to another cell from Sheet2. If your sheet name has a space in it, put the name in single quotes: ='My Data'!A1.

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

The cell is probably formatted as text. Click on the cell, delete what is in it, and retype the formula starting with the equals sign. If that does not work, right-click the cell, choose Format Cells, and change the format from Text to Number or General. Then retype the formula.

Can I write a formula that uses data from multiple ranges?

Yes. =SUM(A1:A10,C1:C10) adds all numbers in A1 through A10, plus all numbers in C1 through C10. The comma tells Excel to include both ranges. You can add as many ranges as you need, separated by commas.

What happens if I copy a formula to the right instead of down?

Excel adjusts the column letters instead of the row numbers. If you copy =A1+B1 from C1 to D1, it becomes =B1+C1. The columns shift, but the row stays the same. This is useful for creating formulas that work across columns as well as down rows.