Excel 2000 percentage function

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

What function is used in Excel 2000 to calculate
percentage? I have a net sales figure and gross profit
margin and want to calculate % gross margin.
 
There is no such function, if you have sell price in A1 and cost in A2 then
this formula will do it

=(A1-A2)/A1

format as percentage
 
Joel,
I think Peo misread your question. If Sales are in A1 and the profit margin
is in B1 then the profit figure is A1*B1. This assumes B1 has a true
percentage value - it is showing something like 40% or 0.4. If it is showing
a value such as 40, use =A1*B1/100

Bernard
 
Back
Top