Everyday math & dates
Tip Calculator
Enter the bill, pick a tip percentage and say how many people are splitting it.
Your result will appear here.
How it's calculated
The tip is the bill times the tip percentage. Add it to the bill and divide by the number of people to get each share.
Per person = Bill × (1 + Tip %) ÷ People
How to do it in Excel
=ROUND(B1*(1+B2)/B3, 2)- Bill in B1, tip in B2 as a percentage, people in B3.