Finance
Work out markup on cost
=(A2-B2)/B2How it works in Excel
- A2-B2 is the profit: price minus cost.
- Dividing by B2 compares it to the cost.
- Format the cell as a percentage.
- Markup is always a higher percentage than margin on the same sale.
The idea in general
It answers: "How much did I add on top of what I paid?"
What I assumed
- The price is in A2 and the cost is in B2.
Check the result on your own data before relying on it.