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