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

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

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

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

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

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

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

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

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