← Spreadsheets
Split a bill that did not split evenly
Four people, but only three drank the wine and two had dessert. This is the arithmetic everyone does badly in their head at the end of a meal.
workbook.truecalc.appOpen in full
- Total with service
- 304.44
- Even split, four ways
- 76.11
- Wine, three ways
- 18.67
B9
B10
D4
Verified at build timeThese figures are produced by running the grid above through the engine during the build. If the engine ever disagrees with them, this page does not ship.
ROUND here rounds half away from zero, so 10.625 becomes 10.63 — which is what Google Sheets does, and what several JavaScript spreadsheet libraries do not.
Take it further
Free and anonymous. A shared link lives for up to 90 days and needs no sign-in at either end.