Thread
:
Calculating Net from Gross
View Single Post
#
5
Posted to microsoft.public.excel.misc
Dave O
external usenet poster
Posts: 427
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
Reply With Quote
Dave O
View Public Profile
Find all posts by Dave O