gross margin formula??

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

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

Thanks Tim
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gross margin 4
Calculate Margins 3
how do i set up a profit margin formula 4
Help with formulae 3
Formula after division 1
anyone have a basic sales tracker 1
Gross Margin Formulas 1
Vlookup 1

Back
Top