View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default 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