gross margin formula??

Tim · Mar 8, 2004

Hi can anybody tell me how to make a gross margin formula?

Thanks Tim

Norman Harker · Mar 8, 2004

Hi Tim!

Using:
Gross Margin = (Price - Cost)/Price

Cost is in A1.
Price is in B1,

=(B1-A1)/B1
Format as percentage

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.