The = + - * / guide
Every formula starts with =. After that you point at cells and join them with +, -, * or /: =B2*B3 multiplies the hours in B2 by the rate in B3, and changes when either does.
The four operators
| Sign | Does | Example |
|---|---|---|
+ | adds | =B8+B4 |
- | subtracts | =B9-B5 |
* | multiplies | =B2*B3 |
/ | divides | =B10/B6 |
Excel doesn't use x or ÷. =B2xB3 looks like a name to Excel, so it shows #NAME?.
Point at cells, don't type the numbers
=12*45 gives the right fee today. When the hours change, it doesn't. =B2*B3 reads the cells every time, so the invoice follows whatever is in them. Type =, click B2, type *, click B3, press Enter.
Build on the cell above
A formula can use another formula's result. The fee is in B8, so the total is =B8+B4, and what's left to pay is =B9-B5. If the rate changes, all of them update in one go.
Common mistakes
- No = at the start.
B2*B3without the = is just text, and the cell shows those letters. - Subtracting the wrong way round.
=B5-B9takes the total away from the deposit and gives a negative number. - Dividing the wrong amount. The monthly payment is a share of what's still to pay, not of the full total.
- A cell formatted as Text. In real Excel, a formula typed into a Text cell stays text. Set the cell back to General and type it again.
Next: SUM for long columns, and brackets for formulas that mix + and /.
FAQ
- How do I write a formula in Excel?
- Click the cell, type =, then the calculation, using cell addresses: =B2*B3. Press Enter to see the result.
- What is the multiply sign in Excel?
- The asterisk, *. =B2*B3 multiplies B2 by B3. An x is not read as multiply.
- Why does my Excel formula show as text?
- Either it doesn't start with =, or the cell was formatted as Text before you typed it. Add the =, or set the format to General and enter the formula again.
- Should I type numbers or cell references in a formula?
- Cell references. The formula then updates when the numbers change, and anyone can see where each number comes from.



































































