Thread
:
Calculating Net from Gross
View Single Post
#
2
Posted to microsoft.public.excel.misc
Peo Sjoblom
external usenet poster
Posts: 3,268
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
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom