Thread: Excel % Question
View Single Post
Old 04-01-2011, 22:03   #9
punky
Inactive
 
Join Date: Jun 2003
Age: 44
Posts: 14,750
punky has a golden aurapunky has a golden aura
punky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aura
Re: Excel % Question
Quote:
Originally Posted by LSainsbury View Post
Top man - cheers!
Actually, you were right the first time. £100 = £83.33 net and £16.67 VAT.

it's definitely

=E13/1.2

If you add 20% of 83.33 to 83.33 it equals 99.996 (i.e. £100)

Sorry, long day!
punky is offline   Reply With Quote