Cells and formulas · Divide, brackets and percentagesWorks in: all current Excel versions, Google Sheets
Divide with /
/ (the slash, next to the right Shift key) divides. This household budget is for two people, so each person's share of a cost is the cost divided by 2.
Typing a number like 2 straight into a formula is fine when it never changes; anything that might change belongs in a cell.
Syntax
=C2/2
Common mistakes
- Using a backslash
\instead of/. - Dividing the wrong way round:
=2/C2is 2 ÷ 1,200, a tiny number.
Tap Try it to split the rent between the two of them.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Type | Budget | Actual | Per person |
| 2 | Rent | Fixed | $1,200.00 | $1,200.00 | |
| 3 | Groceries | Variable | $450.00 | $512.40 | |
| 4 | Utilities | Fixed | $160.00 | $148.75 | |
| 5 | Transport | Variable | $120.00 | $96.50 | |
| 6 | Phone & internet | Fixed | $65.00 | $65.00 | |
| 7 | Eating out | Variable | $150.00 | $203.10 | |
| 8 | Subscriptions | Fixed | $38.00 | $44.97 | |
| 9 | Gym | Fixed | $40.00 | $40.00 | |
| 10 | Gifts | Variable | $60.00 | $25.00 | |
| 11 | Savings | Fixed | $300.00 | $300.00 |
Tap Try it to type =C2/2 into E2.
Go deeper: Spreadsheet formula basics