When you print several pieces on one parent sheet (2-up, 4-up, 8-up), you need fewer sheets than pieces. Divide and round up to get the press-sheet count.
Round up because a partial sheet still consumes a whole sheet.
The example
500 business cards printed 4-up on each parent sheet.
| A | B | |
|---|---|---|
| 1 | Label | Value |
| 2 | Pieces needed | 500 |
| 3 | Up per sheet | 4 |
| 4 | Sheets needed | 125 |
The formula
Divide pieces by the up-count, then round up:
How it works
How imposition affects sheet count:
- Each parent sheet carries several finished pieces — the 'up' count (B3).
B2/B3divides the pieces by how many fit per sheet.- ROUNDUP forces any fraction to the next whole sheet, since you can't run a partial sheet.
- 500 ÷ 4 = 125 sheets exactly here; 501 cards would need 126.
Add a waste allowance for setup and makeready — a few extra sheets per run keeps you covered.
Try it: interactive demo
Enter pieces and the up-per-sheet — get the sheet count.
Variations
Add makeready waste
Tack on a fixed number of setup sheets.
Double-sided, same up-count
Front and back on one sheet don't change the count if it's the same N-up both sides.
Pitfalls & errors
Use ROUNDUP, not ROUND. Rounding to nearest could leave you a sheet short on the last few pieces.
Always add makeready/waste sheets for press setup; the formula gives the minimum, not the order quantity.
Practice workbook
Frequently asked questions
Why round up instead of nearest?
Does double-sided double the sheets?
Should I add waste?
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