What a formula is and how Excel reads it

A formula in Excel is an instruction that tells the program to perform a calculation or operation on the numbers or text in your cells. Every formula starts with an equals sign (=), which signals to Excel that what follows is a formula, not just text you typed. Without that equals sign, Excel treats whatever you type as plain text and does nothing with it.

When you press Enter after typing a formula, Excel reads it from left to right, follows the order of operations (multiplication and division before addition and subtraction), and displays the result in that cell. 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 the actual formula you wrote.

The simplest formulas add, subtract, multiply, or divide. A formula like =10+5 will show 15. A formula like =A1+A2 will add whatever numbers are sitting in cells A1 and A2. This is the core idea: you write an instruction, Excel carries it out, and you see the result.

Key Takeaways

  • Every formula must start with an equals sign, or Excel will treat it as text instead of an instruction.
  • You can reference cell addresses (like A1 or B3) in your formula, and Excel will use whatever number is in that cell.
  • The formula bar at the top shows the actual formula; the cell itself shows only the result.
  • Common functions like SUM, AVERAGE, and COUNT let you perform operations on groups of cells without typing each one individually.
  • If a formula shows an error code like #REF! or #DIV/0!, it means Excel found a problem — usually a missing cell or a division by zero.

The steps to enter a basic formula

Click on the cell where you want the answer to appear. This is where the result will show up once you finish. Then type the equals sign to start your formula. If you forget this step, Excel will not recognize what you type as a formula.

Type the formula itself. This might be something simple like =5+3, or it might reference cells, like =A1+B1. You can also mix numbers and cell references: =A1+10 is perfectly valid. As you type, you will see the formula appear both in the cell and in the formula bar above.

Press Enter when you are done. Excel will read the formula, perform the calculation, and display the result in the cell. The formula bar will still show your formula if you click on that cell again, but the cell itself shows only the answer.

Using cell references instead of typing numbers

The real power of formulas comes from referencing cells instead of typing numbers directly. If you have a price in cell A1 and a quantity in cell B1, you can write =A1*B1 to multiply them. If the price or quantity changes later, the formula automatically recalculates — you do not have to rewrite anything.

This also means you can copy a formula to other cells and it will adjust automatically. If you write =A1+B1 in cell C1 and then copy that formula down to C2, Excel changes it to =A2+B2. The cell references shift to match the new row, but the structure of the formula stays the same. This saves enormous amounts of time when you are working with large spreadsheets.

You can also reference cells from a different sheet in the same workbook. The formula would look like =Sheet2!A1+B1, where Sheet2 is the name of the other sheet. This lets you pull data from multiple sheets into a single calculation.

Common functions that do the work for you

Excel includes built-in functions that handle common tasks without you having to write out every step. The SUM function adds a range of cells: =SUM(A1:A10) adds all the numbers from A1 through A10. The colon between the two cell addresses means "everything in between these two cells."

The AVERAGE function calculates the mean of a group of numbers: =AVERAGE(B1:B5) adds up B1 through B5 and divides by how many cells there are. The COUNT function counts how many cells in a range contain numbers (not text or empty cells): =COUNT(C1:C20) tells you how many cells in that range have numbers in them.

Other useful functions include MAX (finds the largest number in a range), MIN (finds the smallest), and IF (performs different calculations based on a condition). An IF formula looks like =IF(A1>100,"High","Low") — if A1 is greater than 100, it displays "High"; otherwise it displays "Low". These functions save time and reduce the chance of mistakes.

What to do when a formula shows an error

If your formula does not work, Excel displays an error code instead of a number. The most common ones are #REF! (you referenced a cell that does not exist or was deleted), #DIV/0! (you tried to divide by zero or by an empty cell), and #VALUE! (you tried to do math on text instead of numbers).

Start by clicking on the cell with the error and looking at the formula bar. Read through the formula and check that all the cell addresses are correct and that the cells actually contain numbers. If you see a cell reference that looks wrong, click on it and fix it. If the error is #DIV/0!, look for a division operation in your formula and make sure the cell you are dividing by is not empty or zero.

Another common mistake is forgetting the equals sign at the start. If you see your formula displayed as text in the cell instead of showing a result, that is usually why. Delete what you typed, start over with the equals sign, and press Enter again.

Copying and pasting formulas to other cells

Once you have written a formula that works, you can copy it to other cells instead of retyping it. Click on the cell with the formula, then press Ctrl+C (or Cmd+C on a Mac) to copy. Select the range of cells where you want the formula to go, then press Ctrl+V to paste.

Excel will automatically adjust the cell references in the formula for each new row or column. If your original formula was =A1+B1 and you paste it into the row below, it becomes =A2+B2. This adjustment happens because Excel assumes you want the formula to work the same way in each row, just with different cells.

If you want the formula to always reference the same cell no matter where you paste it, use a dollar sign before the cell address: =$A$1+B1. Now when you copy this formula, $A$1 stays fixed, but B1 will change to B2, B3, and so on. This is called an absolute reference, and it is useful when you have a constant value (like a tax rate or exchange rate) that should not change when you copy the formula.

Frequently Asked Questions

Can I use formulas with text, or only with numbers?

Most formulas work with numbers, but some functions handle text. For example, CONCATENATE or the ampersand (&) operator joins text together: =A1&" "&B1 combines the text in A1 and B1 with a space between them. Functions like LEN count the number of characters in a text cell. However, math operations like addition and multiplication only work on numbers.

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

The colon tells Excel to include all cells from the first address to the second address. A1:A10 means cells A1, A2, A3, all the way through A10. You can also use a comma to select separate cells that are not next to each other: =SUM(A1,A3,A5) adds only those three cells, skipping A2 and A4.

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

This usually means the cell is formatted as text. Right-click on the cell, select Format Cells, and change the format to Number. Then go back to the cell, press F2 to edit it, and press Enter. Excel will now recognize it as a formula and show the result instead of the text.

Can I use a formula to reference cells in a different Excel file?

Yes, but both files need to be open. The formula looks like =[OtherFile.xlsx]Sheet1!A1, where OtherFile.xlsx is the name of the other file and Sheet1 is the sheet name. If you close the other file, the formula may show an error until you open it again.