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.
 
Thanks i also req Gross profit in percentage, is that easy to do as well

Mike
 
excellent answer, can someone tell me how to get gross profit please
 
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
 
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

Match Inconsistant entires bewteen days 1
GP Formula Needed 5
To find out % of profit 4
Formula for calculating price 1
how to work out gross profit on items 1
Calculating Profits 2
multiple IIf statement doesn't work - please help 0
Can I make A-B=C 6

Back
Top