# How to Make a Formula in Excel (Step by Step)

Excel formulas are the instructions you type into a cell to calculate something, and every one of them starts with an equals sign. This guide shows you how to make a formula in Excel step by step, using cell references and arithmetic operators, then walks through a small order sheet so you can see each result. By the end you will know how to make formula in Excel for totals, and you will recognize the errors that stop formulas from working.

## Quick Answer

- Every formula begins with `=`. Without it, Excel treats your typing as text.
- A formula combines cell references like `B2` and `C2` with operators like `*` for multiply and `+` for add.
- Type the formula in the cell where you want the answer, then press Enter.
- Copy a formula down a column and the references adjust to each row automatically.
- Use `SUM` with a range such as `D2:D4` to add a block of cells in one formula.

## Before You Start

You need a workbook with data already typed into cells. A formula reads values from other cells, so the numbers must exist first. If you are new to the idea of a formula at all, [Excel Formula Basics: What Formulas Are and How to Write Them](/blog/data-analysis/excel-formula-basics) covers the concepts before you start typing.

Know these three building blocks.

**The equals sign.** Excel reads anything after `=` as a calculation. Type `2+2` and you get the text "2+2". Type `=2+2` and you get 4.

**Cell references.** A reference names a cell by its column letter and row number. `B2` is column B, row 2. References let a formula update when the underlying numbers change.

**Operators.** These are the symbols that tell Excel what to do.

| Operator | Meaning | Example |
|---|---|---|
| `+` | Add | `=B2+C2` |
| `-` | Subtract | `=B2-C2` |
| `*` | Multiply | `=B2*C2` |
| `/` | Divide | `=B2/C2` |
| `^` | Raise to a power | `=B2^2` |

Excel follows the standard order of operations. Multiplication and division happen before addition and subtraction. Parentheses override that order, and they are the standard way to make the intended grouping explicit in a formula [1].

$$=B2+C2*D2$$

In the formula above, `C2*D2` is calculated first, then `B2` is added. Writing `=(B2+C2)*D2` forces the addition first.

## Step by Step

1. **Click the cell where the answer should appear.** For a line total, that is the cell in the same row as the price and quantity you want to multiply.
2. **Type `=`.** This switches the cell into formula mode. Nothing is calculated until you finish.
3. **Type the first cell reference.** Click the cell instead of typing it if you prefer. Excel inserts the reference for you.
4. **Type the operator.** For a line total, type `*` to multiply.
5. **Type the second cell reference.** The formula now reads something like `=B2*C2`.
6. **Press Enter.** Excel calculates the result and moves the selection down one cell. The formula stays in the cell you typed it in.
7. **Check the result against the numbers you can see.** If the price is 2.5 and the quantity is 4, the answer should be 10.
8. **Copy the formula to the rows below.** Select the cell, copy it, select the target cells, and paste. The references shift to match each row.
9. **Add a total formula.** In a cell below the column of results, type `=SUM(` then select the range of cells to add, close the bracket, and press Enter.

If you only need to add a single column of numbers, [How to Sum a Column in Excel (Step by Step)](/blog/data-analysis/how-to-sum-a-column-excel) covers the shortcuts in more detail.

## Worked Example

The sheet below is a small order list with four items. Column A holds the item name, column B the price, column C the quantity, and column D the line total. Each line total multiplies price by quantity, and the grand total adds the line totals.

| | A | B | C | D |
|---|---|---|---|---|
| **1** | Item | Price | Quantity | Line Total |
| **2** | Notebook | 2.5 | 4 | `=B2*C2` -> displays $10.00 |
| **3** | Pen | 1.2 | 10 | `=B3*C3` -> displays $12.00 |
| **4** | Backpack | 35 | 1 | `=B4*C4` -> displays $35.00 |
| **5** | Grand Total | | | `=SUM(D2:D4)` -> displays $57.00 |

Cell D2 holds `=B2*C2`. Excel multiplies 2.5 by 4 and displays $10.00. Cell D3 holds `=B3*C3`, which multiplies 1.2 by 10 and displays $12.00. Cell D4 holds `=B4*C4`, which multiplies 35 by 1 and displays $35.00.

Cell D5 holds `=SUM(D2:D4)`. The `SUM` function adds every value in the range from D2 through D4 and displays $57.00. That total is 10 plus 12 plus 35.

Notice that D5 does not repeat the multiplication. It adds the results already sitting in column D. If you later change the quantity in C2, the value in D2 updates, and the grand total in D5 updates with it. That chain of dependencies is the main reason to use references instead of typing numbers directly into formulas.

Once your totals are in place, you can turn them into a visual with [How to Make a Chart in Excel (Step by Step)](/blog/data-analysis/how-to-make-chart-in-excel).

## Other Ways to Do It

**Point and click.** Instead of typing `B2`, type `=` and then click cell B2. Excel inserts the reference. Type the operator, click the next cell, and press Enter. This reduces typos in long formulas.

**Use the status bar for a quick check.** Select a range of numbers and Excel shows the sum, average, and count at the bottom of the window. This is a read-only check, not a formula, so nothing is written into a cell.

**Use functions instead of long arithmetic.** `SUM` replaces a chain of plus signs. `AVERAGE` gives the mean of a range. If you want to calculate a mean properly, [How to Calculate the Mean in Excel (Step by Step)](/blog/data-analysis/how-to-calculate-mean-in-excel) shows the function and the pitfalls.

**Use logical tests.** When a formula needs to return one value or another depending on a condition, [How to Use the IF Function in Excel (Step by Step)](/blog/data-analysis/excel-if-function-step-by-step) walks through the arguments.

**Fill down instead of copying.** Drag the small square at the bottom right corner of the selected cell to fill the formula into the cells below. The references adjust the same way they do with copy and paste.

## Troubleshooting

**The formula shows as text.** The cell is probably formatted as text, or the entry is missing the leading `=`. Check the formula bar. If you see `B2*C2` with no equals sign, Excel stored it as text.

**You see `#VALUE!`.** One of the referenced cells contains text instead of a number. Check the cells the formula points to.

**You see `#REF!`.** A referenced cell was deleted, so the reference no longer points anywhere. Rebuild the formula against the cells that still exist.

**You see `#####`.** The column is too narrow to display the result. Widen the column. The value itself is fine.

**The result is wrong but no error appears.** Check the order of operations. A missing pair of parentheses is the usual cause. Also confirm the formula points at the cells you think it does by clicking the cell and reading the formula bar.

**The total does not change when you edit a number.** The total may be a typed number instead of a formula. Click it and look at the formula bar. A real total starts with `=`.

## Common Mistakes

- **Leaving off the equals sign.** Excel stores the entry as text and shows it exactly as typed. Fix it by editing the cell and adding `=` at the start.
- **Typing numbers instead of references.** `=2.5*4` works once but never updates. Use `=B2*C2` so the formula follows the data.
- **Forgetting parentheses in mixed formulas.** `=B2+C2*D2` multiplies first. Write `=(B2+C2)*D2` when you want the addition first [1].
- **Mixing text and numbers in one calculation.** A cell holding "10 items" is text, not the number 10. Keep numeric cells numeric.
- **Copying a formula without checking the references.** Copying usually adjusts references correctly, but a reference that was meant to stay fixed will shift. Check the pasted formulas.
- **Summing the wrong range.** `=SUM(D2:D4)` stops at row 4. If you add a row 5, extend the range or leave a spare row inside it.

## Limitations

A formula only recalculates what you point it at. It cannot tell whether the numbers you typed are correct, whether a price is current, or whether a quantity makes sense. If B2 holds 2.5 because of a data entry slip, every formula that reads B2 inherits the error, and the grand total will be wrong in a way that looks perfectly normal.

Formulas also break quietly when the sheet structure changes. Insert a row inside a summed range and Excel usually adjusts the range for you, but delete a referenced cell and you get `#REF!`. Copying formulas between workbooks can leave references pointing at the wrong file. For anything you rely on, keep the source data in a stable layout and check a few results by hand.

## Frequently Asked Questions

### How do I start a formula in Excel?

Type `=` in the cell, then type or click the cells you want to use, add the operators, and press Enter. The equals sign is what tells Excel to calculate instead of storing text. Everything after it is read as an expression.

### What is the difference between a formula and a function?

A formula is any calculation you write, such as `=B2*C2`. A function is a built-in operation you call inside a formula, such as `SUM`, `AVERAGE`, or `IF`. Functions are formulas too, just ones that use a named command instead of only operators.

### Why does my formula show the formula text instead of a result?

The cell is likely formatted as text, or the entry is missing the leading equals sign. Select the cell and check the formula bar. If the text appears there without `=`, add it. If the format is text, change the cell format to General and re-enter the formula.

### How do I add up a column of numbers?

Use `=SUM(` and then select the range of cells, for example `=SUM(D2:D4)`, and press Enter. This adds every value in the range in one formula. It updates automatically when the numbers inside the range change.

### Can I use a formula to multiply two columns?

Yes. Put `=B2*C2` in the first row of the results column, then copy or fill that formula down the column. Each copied row adjusts its references, so row 3 becomes `=B3*C3` and row 4 becomes `=B4*C4`.

## References

1. [Altman DG, Bland JM (2011). Brackets (parentheses) in formulas. BMJ](https://doi.org/10.1136/bmj.d570)

## Further Reading

- [Broman KW, Woo KH (2018). Data Organization in Spreadsheets. The American Statistician](https://doi.org/10.1080/00031305.2017.1375989)
- [Ziemann M, Eren Y, El-Osta A (2016). Gene name errors are widespread in the scientific literature. Genome Biology](https://doi.org/10.1186/s13059-016-1044-7)
- [Microsoft Support: Excel help and learning](https://support.microsoft.com/en-us/excel)
- [McCullough B, Heiser DA (2008). On the accuracy of statistical procedures in Microsoft Excel 2007. Computational Statistics & Data Analysis](https://doi.org/10.1016/j.csda.2008.03.004)
- [Abeysooriya M, Soria M, Kasu MS et al. (2021). Gene name errors: Lessons not learned. PLOS Computational Biology](https://doi.org/10.1371/journal.pcbi.1008984)

## Related Articles

- [How to Make a Chart in Excel (Step by Step)](/blog/data-analysis/how-to-make-chart-in-excel)
- [How to Make a Line Chart in Excel (Step by Step)](/blog/data-analysis/how-to-make-line-chart-excel)
- [How to Sum a Column in Excel (Step by Step)](/blog/data-analysis/how-to-sum-a-column-excel)
- [Excel Formula Basics: What Formulas Are and How to Write Them](/blog/data-analysis/excel-formula-basics)
- [How to Make a Bar Chart in Excel (Step by Step)](/blog/data-analysis/how-to-make-bar-chart-excel)