Junk jobs are priced by the fraction of the truck they fill. Divide the load volume by the truck's capacity to turn a guess into a clean percentage.
A 9-cubic-yard load in a 15-yard truck is 60% full — the fraction that sets the price tier.
The example
Three loads, each in cubic yards, against the truck's capacity.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Job | Load (cu yd) | Truck (cu yd) | Fill % |
| 2 | Garage cleanout | 9 | 15 | 60% |
| 3 | Single couch | 3 | 15 | 20% |
| 4 | Full estate | 15 | 15 | 100% |
The formula
Format the result as a percentage:
How it works
Fill percent is a fraction of capacity:
B2is the load volume, in cubic yards.C2is the truck's total capacity, in the same units.- Dividing gives the fraction filled; format the cell as a percentage to read it as 60%.
Map the percent to your price tiers (quarter, half, three-quarter, full) with a lookup or nested IF.
Try it: interactive demo
Enter the load volume and the truck capacity in cubic yards.
Variations
Snap to a price tier
Round the fill up to the nearest quarter to match common pricing tiers.
Pitfalls & errors
Use the same units top and bottom. Cubic yards over cubic feet gives a wildly wrong percent.
If the cell shows 0.6 instead of 60%, apply the Percent format (Ctrl+Shift+5).
Practice workbook
Frequently asked questions
My result shows 0.6, not 60%.
How do I turn fill into a price?
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