Most junk jobs are a fraction of a truck. Price the full load, take the share you are actually hauling, and MAX keeps a single-item pickup above the minimum.
A $550 full load at half fill is $275; a single item at one-eighth computes $69 but bills the $89 minimum.
The example
Three pickups, each with the full-load price, fill fraction, and single-item minimum.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Pickup | Full load | Fill | Minimum | Price |
| 2 | Garage cleanout | $550 | 1.00 | $89 | $550.00 |
| 3 | Half load | $550 | 0.50 | $89 | $275.00 |
| 4 | Single item | $550 | 0.125 | $89 | $89.00 |
The formula
MAX floors the fractional price at the single-item minimum:
How it works
Scale the full price by how much of the truck you fill:
B2*C2takes the full-load price and multiplies by the fill fraction.D2is the minimum that covers a stop for one small item.MAXreturns the larger, so tiny loads still cover the trip.
Price by visible truck fill — quarter, half, three-quarter, full — and enter the fraction as a decimal.
Try it: interactive demo
Enter the full-load price, fill fraction, and minimum.
Variations
Snap to fill tiers
Round the fraction up to the nearest quarter truck.
Add a stairs or heavy fee
Add a flat surcharge for stairs or heavy items.
Pitfalls & errors
Enter the fill as a decimal (0.5), not a percent typed as 50 — 50 would price fifty full trucks.
Price on visible fill at the curb, not on weight — customers understand a half-full truck far better than pounds.
Practice workbook
Frequently asked questions
How should I enter the fill?
Can I round to set tiers?
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