Rush work disrupts a tailor's schedule, so most shops add a surcharge when the pickup date is less than three days away. An IF test on the days of notice applies the rush percentage only when it is earned and leaves normal jobs untouched.
A $120 suit with 2 days notice at a 50% rush rate adds $60.00 for a $180.00 total.
The example
Three worked examples. Change any yellow input in the practice workbook and the results recalculate.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Case | Price | Days | Rush rate | Rush fee | Total |
| 2 | Hem | $25 | 5 | 50.0% | $0.00 | $25.00 |
| 3 | Suit | $120 | 2 | 50.0% | $60.00 | $180.00 |
| 4 | Dress | $80 | 1 | 25.0% | $20.00 | $100.00 |
The formula
Here is the formula, built directly from the inputs:
How it works
Here is the logic, one piece at a time:
C2<3tests whether the job is a rush.B2*D2is the price times the rush percentage.0is returned for normal jobs.B2+E2adds the fee to the base price.
Keep every number in its own input cell so the formula never needs editing.
Try it: interactive demo
Enter the values below.
Variations
Tiered rush
Higher fee for same-day work.
Flat rush fee
Charge a flat $15 instead.
Pitfalls & errors
Decide whether day zero counts as a rush. Days under 3 includes same-day jobs.
Enter the rush rate as 50% or 0.5, not 50 in a percent-formatted cell.
Keep the cutoff in a cell so you can raise it during holiday season.
Practice workbook
Frequently asked questions
Why a percentage instead of a flat fee?
Can I exempt regular customers?
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