Net profit

  • Thread starter Thread starter mASSIVEMIKE
  • Start date Start date
M

mASSIVEMIKE

Hi
I have a purchase price in A1 0f 1.12 and a selling price in A2 of 1.95
how do i get the net profit please

RegRDS
mIKE
 
=A2-A1 would give a profit of 0.83. But if that is a gross profit you may
wish to provide additional information on the deductions required to derive
a net profit.
 
Hi

=(A2-A1)/A2*100
would give the profit as a percentage of Sales

=(A2-A1)/A1*100
would give the percentage markup.

In both cases, you could format the cell as percentage and omit the *100
form the formulae
 
I'm sure someone will provide the answer, but I don't think that's going to help
you. You would be better off if you learned how to ferret out the answer
yourself, such as googling "gross profit" or skipping fewer classes.
 
Thanks Roger that does the trick, thanks for your help. IT makes a change
from the other stupid replies i got, whats the point of a forum with nutters
like that on it, once again thanks
 
Back
Top