Thread: Margin Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Margin Formula

You probably want % margin, which is:

=(b1-a1)/b1

Regards,
Fred.

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