View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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