Margin Formula for Excel.

[Broccers]

Guys,

For the last however many years my trusty margin calculator has marked up our prices. We now have a large project on where I need to apply Margin (not mark up) to a set of costs in Excel.

Can anyone tell me the formula for this calculation please.

Simon.

[Broccers]

Margin and Mark up are 2 very different calculations. From your example ;

Cost : £ 50
Margin : 10 percent
Sell is the £ 55.55

Quite a lot of people confuse markup with margin.

In the meantime from posting this a good friend of mine has provided the formula I needed to input in Excel.

For those interested it is :

X=(100/(100-B7))*B6

Where B7 = Margin
B6 = Cost
X = Sell

[Broccers]

GreenV8S said:

Not trying to be funny, but if a simple formula like that isn't obvious to you, I would question whether you are the right person to be working out margins.

Apologies for not being an expert in Excel - my remit as company owner doesn't extend that far.

Thanks for the constructive post.