Hello All
I am currently using the following formula to calculate my profit margins on sales (where profit margin is defined as the percentage of the final selling price that is profit)
Margin=("Selling Price"-"Cost Price")/"Selling Price"
In the above, Selling Price and Cost Price are inputs in Currency, Margin is the output as a percentage.
I would like a formula that can calculate a final selling price from a Margin Percentage and the cost price (i.e. how much should I sell something for to make x% Margin) but I cant figure it out.
Any ideas?
I am currently using the following formula to calculate my profit margins on sales (where profit margin is defined as the percentage of the final selling price that is profit)
Margin=("Selling Price"-"Cost Price")/"Selling Price"
In the above, Selling Price and Cost Price are inputs in Currency, Margin is the output as a percentage.
I would like a formula that can calculate a final selling price from a Margin Percentage and the cost price (i.e. how much should I sell something for to make x% Margin) but I cant figure it out.
Any ideas?
Last edited: