Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to split a bill evenly in Excel and Google Sheets
Topic:Finance basicsExcel & Google Sheets
=ROUND(A2*(1+B2)/C2,2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Bill Total | Tip Rate | People | Each Pays |
| 120 | 0.18 | 4 | |
| 85 | 0.2 | 3 | |
| 200 | 0.15 | 5 | |
| 60 | 0.18 | 2 |
=ROUND(A2*(1+B2)/C2,2)→35.4
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 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).
Tips
- 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).
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
How do I handle unequal splits?
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).
How do I add tax separately from tip?
Add a Tax Rate column (E): =ROUND(A2*(1+B2+E2)/C2,2).
More on Finance basics
See all →How-to
How to calculate compound interest
Calculate a compounded closing balance from principal, annual nominal rate, compounding frequency and years, then separate the interest earned.
How-toHow to calculate the effective annual interest rate
Convert a positive nominal annual rate and a whole-number compounding frequency into an effective annual rate with EFFECT.
How-toHow to calculate the break-even point in units
Divide fixed costs by unit contribution margin and round up to whole units, with an explicit message when the margin is nonpositive.
How-toHow to calculate tiered commission
Apply different commission rates by sales tier using IFS. Works in Excel 2019/365 and Google Sheets.
How-toHow to calculate net pay
Calculate take-home (net) pay by subtracting every deduction from gross salary, with worked examples for fixed amounts, percentage tax, and slab-based tax. Excel and Google Sheets.
How-toHow to calculate gross margin
Compute gross margin percentage as (price − cost) / price. Identical in Excel and Google Sheets.