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

#### AkaTrouble

##### Well-known Member
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
This article has all you need. We work off Margin also and I need to refer to it every so often.

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

#### 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

Replies
8
Views
222
Replies
1
Views
460
Replies
2
Views
356
Replies
3
Views
312
Replies
1
Views
398

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

### 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