Formula
Gross margin = (Selling price − Cost) ÷ Selling price. Markup = (Selling price − Cost) ÷ Cost. Target-price formula: Price = Cost ÷ (1 − Margin).
Determine optimal selling prices, compare margin with markup, and project profit across a product batch.
Convert between gross margin and markup, calculate selling price from cost and estimate product profit.
Gross margin = (Selling price − Cost) ÷ Selling price. Markup = (Selling price − Cost) ÷ Cost. Target-price formula: Price = Cost ÷ (1 − Margin).
Use target-margin mode to solve for the selling price, or price-analysis mode to calculate the margin and markup implied by a selling price. Quantity inputs extend the result to total revenue and profit.