Skip to main content

Limited time: save up to 25% on spreadsheet models and templates.Explore templates

10XSheets

Free calculator

Tip calculator

Enter your bill, pick a tip percent, and set how many people split evenly. We show tip, grand total, tip per person, and total per person with the same definitions you would drop into a spreadsheet cell. This is equal split only—not itemized checks, not payroll, and not guidance on local tipping law.

Educational illustration only. Tipping customs and service charges vary by venue and jurisdiction; this page is math on the numbers you type. It is not tax, labor-law, or legal advice.

When to use this calculator

Fast restaurant-style checks before you split cash or settle a card—same spirit as a scratch block in Sheets or Excel.

  • Figure tip and total from the printed check when everyone pays the same share.
  • Compare a few percent presets without mental arithmetic on a noisy floor.
  • Copy the ratio pattern into a workbook row to match this page’s definitions.
  • Jump to the percentage calculator when you need generic percent-of or percent-change drills beyond tipping.
How do you calculate a tip and split here?

We keep one transparent path: percent of the bill you enter, then equal shares for every diner.

Tip and total

Tip = bill × (tip percent ÷ 100), rounded to two decimals (cents). Grand total = bill + rounded tip—same order you would usually speak aloud at the table.

Per person (equal split)

Tip per person = rounded tip ÷ people. Total per person = grand total ÷ people. We do not allocate unequal shares, cover minimum-wage tip rules, or model pre-tax vs post-tax bases in v1—type the bill you want the percent applied to.

What we do not model

Sales tax lines, automatic gratuity, currency conversion, and itemized bills each need their own assumptions. For travel cash math, see the currency converter; for p % of x drills, see the percentage calculator.

If your venue adds a service charge, subtract or interpret it according to your policy before using this page—we only see the numbers you supply. For generic percent-of and percent-change jobs, open the percentage calculator. For live reference rates between currencies, open the currency converter.

Google Sheets & Excel

Assume A2 = bill, B2 = tip percent as a plain number (18 means 18%), C2 = people count. Copy the patterns below—rename cells to match your sheet.

Tip amount
=A2*(B2/100)

Round with =ROUND(A2*(B2/100),2) if you need strict cents before splitting.

Grand total (bill + tip)
=A2+ROUND(A2*(B2/100),2)

Matches this page when the tip line is rounded to two decimals first.

Tip per person
=ROUND(A2*(B2/100),2)/C2

Requires C2 ≥ 1; uses the rounded tip in the numerator.

Total per person
=(A2+ROUND(A2*(B2/100),2))/C2

Same order as this page: rounded tip, then divide by people.

Frequently asked questions

How is the tip calculated?

Tip = bill × (tip percent ÷ 100). We round that line to two decimals, add it to the bill for the grand total, then divide by the number of people for equal shares.

How do you split the bill equally?

We divide both the rounded tip and the grand total by the same whole number of people. Everyone gets the same tip share and the same total share—use a spreadsheet if you need different weights per person.

Should the tip be on the amount before tax or after tax?

This page applies the percent to the bill field exactly as you type it. If your receipt shows subtotal, tax, and total, decide which base you want for tipping and type that base here (or adjust mentally). We do not read receipts or infer local tax law.

Can I split unequally between people?

Not on this page—equal split only. For different shares, build a small table in Sheets or Excel with one row per person and your own weights.

When should I use the percentage calculator instead?

Use the percentage calculator for percent of, what percent, reverse whole, and increase/decrease patterns that are not the simple bill × percent tipping line.

What if a service charge is already on the check?

Read your receipt: if a gratuity or service charge is already included, you may not want to add another full tip on top. This tool only multiplies what you enter—policy is yours.

Why can my card terminal total differ by a cent?

We round the tip line to cents before splitting. Some terminals round per person differently or carry extra precision—always reconcile with the printed receipt or POS.

How do I match this in Google Sheets or Excel?

Use the copy cards: =A2*(B2/100) for tip when B2 stores 18 for 18%, then add and divide by C2 people. Wrap with ROUND(...,2) if you want strict cent parity with this page.

Is this tax, labor, or tipping-law advice?

No. It is a free educational calculator—not a wage-law guide, not a jurisdiction-specific mandatory gratuity reference, and not a substitute for venue policy or professional advice when money is disputed.