I wonder if someone would be able to re-arrange this formula for me as I've tried an it isn't giving me the correct value.
This formula gives me a Selling Price based on a Cost Price with a Margin %
E2 = Cost Price
F2 = Margin Percentage
K2 = Sell Price
K2 = E2/(1-(F2))
I seem to be unable to re-arrange the formula in Excel so that I can calculate the "ideal" Cost Price based on what I want to achieve as a Margin %
Forgive me if this is not the right forum but I know there are some extremely helpful and clever people here.
Thank you in advance.
This formula gives me a Selling Price based on a Cost Price with a Margin %
E2 = Cost Price
F2 = Margin Percentage
K2 = Sell Price
K2 = E2/(1-(F2))
I seem to be unable to re-arrange the formula in Excel so that I can calculate the "ideal" Cost Price based on what I want to achieve as a Margin %
Forgive me if this is not the right forum but I know there are some extremely helpful and clever people here.
Thank you in advance.