add margin to cost price & calculate cost price from sale price minus margin

[AkaTrouble]

Hi been a while since i have posted and been active hope everyone is doing ok.

i am frustrating myself with something that seems straight forward. My boss works on margin not percentage profit

i need to work with multiple options

1. I know the cost price and the margin i need ...... how do i calculte the sale price including the margin (not simply adding a percentage)

2. I know the sale price and the cost price ..... how do i calculate the margin

3. I know the sale price and the margin ... how do i calculate the cost price

we have margin calculators that have cost / sell / margin options. i simply cannot work out the maths to write a formula in excell

example

£1.00 ADD 30 percent margin = £1.43

£1.43 minus 30 percent marging = £0.99

£1.43 sale price £1.00 cost price = 30 percent margin

hope i make sense and thanks for looking

... Trubs

 

[mrshl9898]

This article has all you need. We work off Margin also and I need to refer to it every so often.

Margin Calculator

Use the online margin calculator to find out the sale price, the cost or the margin percentage itself.

www.omnicalculator.com

C2 =A2/(1-B2)
A3 =C3*(1-B3)
B4 =1-(A4/C4)

 

[AkaTrouble]

mrshl9898 Thank You​

exactly what i needed and all 3 senarios answered with working formula's

the say it is only easy once you know