Albums price from a base (with included spreads) plus a per-spread charge for extras. Base plus extra spreads times the per-spread price gives the album total.
The example
$500 base (10 incl), 15 spreads, $40 each.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Extra spreads | 5 × $40 |
| 3 | Album total | → $700 |
The formula
The formula:
How it works
How it works:
- The base price includes a set number of spreads (e.g. 10).
- MAX(spreads − included, 0) counts only the extras — never negative.
- Multiply extras by the per-spread price and add to base.
- Layer cover and upgrade options as add-ons on top.
Base-plus-extras pricing nudges the sale up without a hard ceiling. Clients almost always want a few more spreads than the base includes, and a clear per-spread price makes the upsell frictionless and fair. The MAX(…, 0) floor means an album at or under the included count simply charges the base — no awkward negative “credit” — while bigger albums scale smoothly.
Try it: interactive demo
Base, included, spreads, per-spread.
Variations
Extra spreads count
Beyond included:
With cover upgrade
Add-on:
Profit on album
Above lab cost:
Pitfalls & errors
Floor extras at zero. MAX stops a small album going negative.
Spread vs page. A spread is two facing pages — price the unit you quote.
Cover lab cost. Confirm the album profits after the lab bill.
Practice workbook
Frequently asked questions
How do I price a photo album in Excel?
Why use MAX for extra spreads?
What's a spread vs a page?
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