| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Net profit
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Net profit
=a2-a1
-- Regards, Fred "mASSIVEMIKE" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Net profit
=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. -- David Biddulph "mASSIVEMIKE" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Net profit
Thanks i also req Gross profit in percentage, is that easy to do as well
Mike "David Biddulph" wrote: =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. -- David Biddulph "mASSIVEMIKE" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Net profit
Yes it is.
-- Regards, Fred "mASSIVEMIKE" wrote in message ... Thanks i also req Gross profit in percentage, is that easy to do as well Mike "David Biddulph" wrote: =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. -- David Biddulph "mASSIVEMIKE" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Net profit
excellent answer, can someone tell me how to get gross profit please
"Fred Smith" wrote: Yes it is. -- Regards, Fred "mASSIVEMIKE" wrote in message ... Thanks i also req Gross profit in percentage, is that easy to do as well Mike "David Biddulph" wrote: =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. -- David Biddulph "mASSIVEMIKE" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 -- Regards Roger Govier "mASSIVEMIKE" wrote in message ... Thanks i also req Gross profit in percentage, is that easy to do as well Mike "David Biddulph" wrote: =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. -- David Biddulph "mASSIVEMIKE" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Net profit
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. -- Regards, Fred "mASSIVEMIKE" wrote in message ... excellent answer, can someone tell me how to get gross profit please "Fred Smith" wrote: Yes it is. -- Regards, Fred "mASSIVEMIKE" wrote in message ... Thanks i also req Gross profit in percentage, is that easy to do as well Mike "David Biddulph" wrote: =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. -- David Biddulph "mASSIVEMIKE" wrote in message ... 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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Net profit
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 "Roger Govier" wrote: 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 -- Regards Roger Govier "mASSIVEMIKE" wrote in message ... Thanks i also req Gross profit in percentage, is that easy to do as well Mike "David Biddulph" wrote: =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. -- David Biddulph "mASSIVEMIKE" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| gross profit | Excel Worksheet Functions | |||
| Profit only if B2=33 and C2=18, please help | Excel Discussion (Misc queries) | |||
| Non-profit database? | Excel Discussion (Misc queries) | |||
| Calculating net profit | Excel Worksheet Functions | |||
| Net profit chart | Charts and Charting in Excel | |||
Linear Mode
