How to split a bill with tip
✓ Verified in LibreOffice 25.8.7.3Add the tip and divide by people — the dinner-table classic, made exact.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =ROUND(A2*(1+B2)/C2,2) | A2=bill, B2=tip rate (20% stored as 0.2), C2=people. |
| Google Sheets | =ROUND(A2*(1+B2)/C2,2) | Identical. |
| LibreOffice Calc | =ROUND(A2*(1+B2)/C2,2) | Identical. |
How it works
Bill times (1 + tip) is the grand total; dividing by headcount gives each share: $85 with 20% is $102, split four ways is $25.50 each. Tip on the pre-tax amount instead by applying the rate to a subtotal cell. One rounding subtlety: rounding each share can make the shares not exactly sum to the total (4 × 25.50 works here, but $100/3 → 33.33×3 = 99.99); when the cents must reconcile, compute one person's share as total minus the others.
Verified, not just documented
We ran =ROUND(A2*(1+B2)/C2,2) in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 25.5 — exactly the expected result. Every formula here is confirmed by actually executing it.