Print and Product Markup

Excel Formulas › Photography & Creative

All versions

Prints and albums are sold at a markup over lab cost — a multiplier that covers handling, packaging, and profit. Markup from cost and the resulting margin are the two views every studio needs.


Quick formula: retail price from cost and markup:
=lab_cost * markup_multiple
Lab cost times the markup multiple gives the retail price. A 4x markup on a $12 print is $48.

The example

$12 lab cost, 4x markup.

AB
1ItemValue
212 × 4—
3Retail→ $48

The formula

The formula:

=lab_cost * markup_multiple // cost × markup multiple

How it works

How it works:

  1. Multiply lab cost by the markup multiple (3x–5x is common for prints).
  2. Profit = retail − cost; margin % = profit ÷ retail.
  3. To hit a target margin, price = cost ÷ (1 − target_margin).
  4. Higher markups suit wall art and albums; competitive items take lower ones.

Markup multiple and margin percent are the same fact, stated two ways. A 4x markup is a 75% margin (you keep $36 of a $48 print). Photographers talk in multiples (“I markup 4x”); accountants talk in margin. Knowing the bridge — margin = 1 − 1/multiple — lets you set print prices in whichever language your pricing guide and your books each use.

Try it: interactive demo

Live demo

Lab cost and markup multiple.

Retail · Margin

Variations

Profit per item

Retail − cost:

=lab_cost*markup_multiple - lab_cost

Margin from multiple

Convert:

=1 - 1/markup_multiple

Price for a target margin

From cost:

=lab_cost / (1 - target_margin)

Pitfalls & errors

Markup vs margin. 4x markup = 75% margin — don’t confuse them.

Total lab cost. Include shipping and packaging in cost.

Per product. Wall art and albums carry different multiples than 4x6s.

Practice workbook

📊
Download the free Print and Product Markup practice workbook
A print-markup sheet with the profit, margin-from-multiple, and target-margin variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate print markup in Excel?
Multiply lab cost by the markup: =lab_cost * markup_multiple. A 4x markup on a $12 print is $48.
How do I convert markup multiple to margin?
Use =1 - 1/markup_multiple. A 4x markup is a 75% margin.
How do I price for a target margin?
Divide cost by one minus the margin: =lab_cost / (1 - target_margin).

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: Session price with cost · Album page pricing · Profit margin & markup