Margin Formula

[Lgirl]

I have Cost (column A) and Selling Price (column B). I need a formula to
determine margin. Can anyone help?

 

[Pete_UK]

Well. isn't it just the difference between what you sell it for and
what it cost you?

Try this in C2:

= B2 - A2

Copy this down as far as you need to.

Hope this helps.

Pete

 

[Fred Smith]

You probably want % margin, which is:

=(b1-a1)/b1

Regards,
Fred.