Many shops tip out a percentage of each barber's tips to assistants and the front desk. A tiny percentage table keeps the math fair and transparent.
The barber keeps whatever is left after the tip-outs are subtracted.
The example
A barber earned $300 in tips and tips out 10% to an assistant and 5% to the front desk.
| A | B | C | |
|---|---|---|---|
| 1 | Recipient | Percent | Amount |
| 2 | Assistant | 10% | $30 |
| 3 | Front desk | 5% | $15 |
| 4 | Barber keeps | 85% | $255 |
The formula
Each tip-out is simply total tips times that role's percentage:
How it works
How the split works:
- Put total tips in one cell (here $300) and each recipient's percentage in its own row.
- Multiply tips by each percentage: $300 × 10% = $30 for the assistant, $300 × 5% = $15 for the front desk.
- The barber keeps the remainder: $300 − $30 − $15 = $255, or equivalently $300 × 85%.
- ROUND to two decimals so nobody is shorted or overpaid by a fraction of a cent.
Lock the total-tips cell with $ so you can drag the formula down the percentage column.
Try it: interactive demo
Enter total tips and the two tip-out percentages; see each share.
Variations
Tip out a flat dollar amount
If a role gets a fixed amount instead of a percentage, just subtract it.
Total all tip-outs for the day
Sum the amount column to see what left the barber's pocket.
Pitfalls & errors
Make sure the percentages plus the barber's share add to 100%. If they total more than 100%, the barber's remainder goes negative.
Format the percent cells as Percentage so 10 reads as 10%, not 1000%.
Practice workbook
Frequently asked questions
Should tip-outs be on tips only or total sales?
How do I handle credit-card tip fees?
Can I add more recipients?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class