Need Backwards Profit Margin Formula

Good morning all,

I am trying to develop a formula that can give me the cost price by inputting the sell price and profit margin.

My sell price is $1.25 I want to input a profit margin of 20% and have the result be my desired cost.

Any help would be welcome.

thanks
way~

cell A1: 1.25 (sell price)
cell A2: 20 (profit margin)

cell A3: =A1-(A1*(A2/100))

Based on the input values above, the answer (A3) should be $1.00

See how that goes.

just times the sell price cell by 0.8 e.g =a1/.8

Sorry, multiply by 0.8 e.g a1*.8

Thanks Danwall works like a charm saved me hours.

way~

no worries