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/C2 is 2 ÷ 1,200, a tiny number.

Tap Try it to split the rent between the two of them.

ABCDE
1CategoryTypeBudgetActualPer person
2RentFixed$1,200.00$1,200.00
3GroceriesVariable$450.00$512.40
4UtilitiesFixed$160.00$148.75
5TransportVariable$120.00$96.50
6Phone & internetFixed$65.00$65.00
7Eating outVariable$150.00$203.10
8SubscriptionsFixed$38.00$44.97
9GymFixed$40.00$40.00
10GiftsVariable$60.00$25.00
11SavingsFixed$300.00$300.00

Tap Try it to type =C2/2 into E2.

Go deeper: Spreadsheet formula basics