Moving: Truck Trips Needed

Excel Formulas › Moving & Storage

All versions

A local move with one truck may take more than one load. Divide the total volume by the truck's capacity and round up to plan the number of trips.


Quick formula: Total volume divided by truck capacity, rounded up:
=ROUNDUP(B2/C2,0)

1,400 cubic feet in a 1,000-cubic-foot truck is 1.4 loads, which rounds up to 2 trips.

Functions used (tap for the full reference guide):

The example

Three moves with a total volume and the truck's capacity.

ABCD
1MoveVolume (cu ft)Truck (cu ft)Trips
21-bed apt1,4001,0002
3Studio6001,0001
43-bed house2,6001,0003

The formula

Round up because a partial load still needs a trip:

=ROUNDUP(B2/C2,0) // volume / capacity, round up

How it works

Trips are a capacity division you round up:

  1. B2 is the total volume to move, in cubic feet.
  2. C2 is the truck's usable capacity, in the same units.
  3. Dividing gives raw loads; ROUNDUP turns any leftover into one more full trip.

Multiply trips by round-trip drive time to estimate the schedule, especially for long hauls between sites.

Try it: interactive demo

Interactive

Enter the total volume and the truck capacity in cubic feet.

Variations

Usable capacity

Trucks never pack to 100%. Discount capacity to a realistic fill before dividing.

=ROUNDUP(B2/(C2*FillFactor),0)

Pitfalls & errors

Use usable capacity, not the brochure number — awkward items mean you rarely fill a truck completely.

Same units on top and bottom. Cubic feet over cubic feet; never mix in cubic yards.

Practice workbook

📊
Download the free Moving: Truck Trips Needed practice workbook
Edit the yellow Volume and Truck cells; the Trips column rounds up automatically.

Frequently asked questions

Why round up?
A leftover half-load still requires a full trip, so ROUNDUP turns any fraction into one more run.
Should I use the truck's full capacity?
No. Apply a fill factor (often 80-90%) because furniture and boxes never pack perfectly. Divide by the usable capacity.

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

Related formulas: Moving: Estimate by Cubic Feet · Junk Removal: Truck Fill Percent · Self-Storage: Monthly Revenue

Function references: ROUNDUP