Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate a tip and total in Excel and Google Sheets
Topic:Finance basicsExcel & Google Sheets
=ROUND(A2*B2,2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Subtotal | Tip Rate | Tip Amount | Grand Total |
| 85 | 0.18 | ||
| 120 | 0.2 | ||
| 45 | 0.15 | ||
| 200 | 0.18 |
=ROUND(A2*B2,2)→15.3
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 = Subtotal (bill before tip), Column B = Tip Rate (e.g., 0.18 for 18%).
- 2In C2 enter =ROUND(A2*B2,2) for the tip amount.
- 3In D2 enter =ROUND(A2*(1+B2),2) for the grand total.
- 4Format columns C and D as Currency.
Tips
- Add a dropdown in column B using Data Validation with common tip rates (0.15, 0.18, 0.20) so users can select easily without typing percentages.
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 split the tipped total among several people?
Add a People column (E) and in F2 enter =ROUND(D2/E2,2) to get each person's share.
Should I calculate tip on the pre-tax or post-tax amount?
Customary practice varies — in the US, tipping on the pre-tax subtotal is common; adjust which amount you use in column A accordingly.
More on Finance basics
See all →How-to
How 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 gross margin
Compute gross margin percentage as (price − cost) / price. Identical in Excel and Google Sheets.
How-toHow to calculate compound interest
Compute a compounded future value with principal × (1 + rate)^years using POWER. Identical in Excel and Google Sheets.
How-toHow to calculate cost per unit
Divide total cost by total units to find cost per unit using a simple formula in Excel or Google Sheets.
How-toHow to calculate a selling price from a target margin
Use cost and target gross margin percentage to back-calculate the required selling price in Excel or Google Sheets.
How-toHow to calculate simple interest
Multiply principal, rate, and time to compute simple interest using a straightforward formula in Excel or Sheets.