A missed session still costs you the slot. IF the student attended, bill the full rate; if they no-showed, bill your policy percentage — the same formula enforces the rule every time.
At a 50% no-show policy, a $60 session bills $60 when attended and $30 when missed — no awkward math at the door.
The example
Three sessions, each marked attended or not, with a rate and no-show percent.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Session | Attended | Rate | No-show % | Charge |
| 2 | Ava — Mon | Yes | $60 | 50% | $60.00 |
| 3 | Ben — Tue | No | $60 | 50% | $30.00 |
| 4 | Chloe — Wed | No | $55 | 50% | $27.50 |
The formula
IF picks the full rate or the reduced no-show charge:
How it works
The attendance flag decides the charge:
B2="Yes"tests whether the student showed up.- When true, IF returns the full rate
C2. - When false, it returns
C2*D2— your policy percentage of the rate.
Enter the no-show percent as a formatted percent (50%), not the number 50, or the charge balloons.
Try it: interactive demo
Choose attendance, then enter the rate and no-show percent.
Variations
Full charge on no-show
Some tutors bill 100% for a same-day no-show.
Waive with notice
No charge when the student cancels with enough notice.
Pitfalls & errors
Format the no-show cell as a percent. A literal 50 turns a $60 session into a $3,000 charge.
Put the policy in writing before the first session; the formula enforces a rule the family already agreed to.
Practice workbook
Frequently asked questions
What is a fair no-show fee?
How do I waive the fee with notice?
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