I have attached an example to explain exactly what I am trying to achieve.
I need it to handle if the GP is <100% or >100% also.
Am currently using Excel 2013.
GP Margin Example.xlsx
EG.
If an item cost $25 and I wanted a GP Margin of 25%, it would equate to $33.33.
On a calculator it is worked out by 25/0.75=33.33
(0.75) being 100 < 25(%).
Bookmarks