Net profit

[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

 

[Fred Smith]

=a2-a1

 

[David Biddulph]

=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.

 

[mASSIVEMIKE]

Thanks i also req Gross profit in percentage, is that easy to do as well

Mike

 

[Fred Smith]

Yes it is.

--
Regards,
Fred

Thanks i also req Gross profit in percentage, is that easy to do as well

Mike

 

[mASSIVEMIKE]

excellent answer, can someone tell me how to get gross profit please

 

[Roger Govier]

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

 

[Fred Smith]

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.

 

[mASSIVEMIKE]

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