How to split a bill evenly in Excel and Google Sheets

Excel & Google Sheets

=ROUND(A2*(1+B2)/C2,2)

✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

=ROUND(A2*(1+B2)/C2,2)→35.4

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Formula

Runs server-side · free · no signup

1Column A = Total Bill (before tip), Column B = Tip Rate (e.g., 0.18 for 18%), Column C = Number of People.
2In D2 enter =ROUND(A2*(1+B2)/C2,2) to get each person's share including tip.
3To show the tip amount separately, use =ROUND(A2*B2/C2,2).
4To show total per person without tip: =ROUND(A2/C2,2).

Use CEILING instead of ROUND to always round up to the nearest cent so no one is short: =CEILING(A2*(1+B2)/C2,0.01).

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Give each person a 'share count' in column D (e.g., 1, 2, 0.5). Each person pays: =A2*(1+B2)*D2/SUM($D$2:$D$6).

Add a Tax Rate column (E): =ROUND(A2*(1+B2+E2)/C2,2).

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026