Question
9020 views

Applying a formula to a spreadsheet to calculate gross margin % for items where both List Price and Cost are known

LITTLEJPL asked on
How do I create a formula that expresses a gross margin percentage based upon either an items cost or list price?
2 people had this question

Abuse history


The answered status icon Answer
HansV MVP replied on

Let's say the cost price is in A2 and the list price in B2. Use this formula:

=B2/A2-1

and format the cell with the formula as a percentage.

Kind regards, HansV
www.eileenslounge.com
3 people found this helpful

Abuse history


progress