Tip Calculator

Calculate tip amount and split the bill among any number of people.

100% in your browser — nothing uploaded

Calculate tip and split the bill evenly

Bill amount (total before tip)

People

Tip percentage

Round per-person total

Decimals: use a period or a comma — 99.5 or 99,5.

—Tip

—Total

—Tip per person

—Total per person

Quick reference for this bill

%	Tip	Total	Per person

Excel & Google Sheets formulas

Put the bill amount in A2, the tip percentage as a decimal (e.g. 0.18) in B2, and the number of people in C2.

Tip amount: =A2*B2Total with tip: =A2*(1+B2)Per-person total: =A2*(1+B2)/C2Round up to nearest dollar: =CEILING(A2*(1+B2)/C2, 1)Round down to nearest dollar: =FLOOR(A2*(1+B2)/C2, 1)

SQL query

Calculate the tip and split the bill in a single query:

SELECT
  bill,
  tip_pct,
  guests,
  ROUND(bill * tip_pct, 2)              AS tip_amount,
  ROUND(bill * (1 + tip_pct), 2)        AS total,
  ROUND(bill * tip_pct / guests, 2)     AS tip_per_person,
  ROUND(bill * (1 + tip_pct) / guests, 2) AS total_per_person,
  CEIL(bill * (1 + tip_pct) / guests)   AS rounded_up
FROM bills;

About this tip calculator

Enter the bill amount, choose a tip percentage (10%, 15%, 18%, 20%, 25%, or custom), and set the number of people splitting the bill. The calculator instantly shows the tip amount, total with tip, and per-person share. A quick-reference table shows all preset percentages at once so you can compare before choosing.

The optional rounding feature rounds each person’s share up to the nearest dollar — useful when you want clean numbers instead of chasing exact change. Everything runs in your browser with no data sent anywhere, and the tool includes Excel and SQL formulas for restaurant POS analysis or expense reporting.

FAQ

What is a standard tip percentage?

In the United States, 15–20% is standard for sit-down restaurants. 18% is common for large parties. For counter service, delivery, or takeout, 10–15% is typical. Tipping customs vary widely by country.

How does the rounding work?

When you select "round up," each person’s share is rounded up to the nearest whole dollar. This means the total collected may be slightly more than the exact bill-plus-tip — the extra goes to the tip.

Does this work with non-dollar currencies?

Yes. The calculator works with any currency — just enter the bill amount in your local currency. The percentages and math are the same regardless of currency.