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

AkaTrouble

Well-known Member
Joined
Dec 17, 2014
Messages
1,544
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
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,761
This article has all you need. We work off Margin also and I need to refer to it every so often.


1604611726068.png


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

AkaTrouble

Well-known Member
Joined
Dec 17, 2014
Messages
1,544

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
 

Watch MrExcel Video

Forum statistics

Threads
1,129,382
Messages
5,635,934
Members
416,889
Latest member
dhegs

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top