Calculating Net from Gross
 

I need to be able to calculate the Net price when I only have the Gross
figure. The Gross figure equals Net + 17.5%, but sometimes I need to reverse
this and I don't know the calculation. At present I am using Gross*85.1% but
this is not accuarate in large figures. I have the 2003 version of Excel.
Thank you

Answer: Calculating Net from Gross
 

Calculating Net Price from Gross Price

To calculate the Net price when you only have the Gross figure, you can use the following formula:

Net Price = Gross Price / 1.175

Calculating Gross Price from Net Price

To reverse the calculation and find the Gross Price when you only have the Net Price, you can use the following formula:

Gross Price = Net Price * 1.175

Using the Formulas in Excel

To use these formulas in Excel, simply enter the formula into a cell and replace "Gross Price" or "Net Price" with the appropriate cell reference. For example, if your Gross Price is in cell A1, you would enter the following formula in another cell to calculate the Net Price:

1. =A1/1.175

And if your Net Price is in cell B1, you would enter the following formula in another cell to calculate the Gross Price:

1. =B1*1.175

Calculating Net from Gross
 

With gross in A1

=A1/(1+17.5%)

or if you want to round it to the nearest penny


=ROUND(A1/(1+17.5%),2)


--


Regards,


Peo Sjoblom



"Seldonian Crisis" <Seldonian wrote in
message ...
I need to be able to calculate the Net price when I only have the Gross
figure. The Gross figure equals Net + 17.5%, but sometimes I need to
reverse
this and I don't know the calculation. At present I am using Gross*85.1%
but
this is not accuarate in large figures. I have the 2003 version of Excel.
Thank you

Calculating Net from Gross
 

Say the gross is in G1 and the net is in N1

to get the gross from the net, in G1 enter:
=1.175*G1

to get the net from the gross, in N1 enter:
=N1/1.175
--
Gary''s Student - gsnu200750


"Seldonian Crisis" wrote:

I need to be able to calculate the Net price when I only have the Gross
figure. The Gross figure equals Net + 17.5%, but sometimes I need to reverse
this and I don't know the calculation. At present I am using Gross*85.1% but
this is not accuarate in large figures. I have the 2003 version of Excel.
Thank you

Calculating Net from Gross
 

The way you're thinking about is tripping you up, I think.

If Gross = Net + 17.5% of Net, you can think of this as
Gross = Net x (1+17.5%)

Then applying a little algebra,
Net = Gross / (1+17.5%)

Dave O
Eschew obfuscation