Members ask, and so should you: how many washes a month make the unlimited plan worth it? Divide the monthly price by a single wash and round up.
A $30 plan against a $12 single wash pays off at 3 washes a month — the simple pitch for the membership.
The example
Three plans, each with a monthly price and the price of a single wash.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Plan | Monthly $ | Single wash $ | Washes to justify |
| 2 | Basic unlimited | $30 | $12 | 3 |
| 3 | Deluxe unlimited | $45 | $18 | 3 |
| 4 | Premium unlimited | $60 | $22 | 3 |
The formula
Round up so the member clears the cost:
How it works
The break-even is just a division you round up:
B2is the monthly membership price.C2is what one wash would cost without the plan.- Dividing gives the exact break-even;
ROUNDUPmoves it to the next whole wash, the point where the member comes out ahead.
Use this in your sign-up pitch: "Wash three times a month or more and the plan pays for itself."
Try it: interactive demo
Enter the monthly price and the single-wash price.
Variations
Yearly plan
Compare an annual membership against single washes over the year.
Pitfalls & errors
Round up: at the exact break-even, the member needs one more wash to truly come out ahead.
Compare like wash tiers — a deluxe membership against a basic single wash makes the plan look better than it is.
Practice workbook
Frequently asked questions
Why round up instead of down?
Does this account for time saved?
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