V.A.T how to calculate it

[Guest]

hi all

am new to excel 2007 and have a problem i cant solve as yet.
i've tried the help in excel and office online but cant find what am looking
for.

the problem is am trying to calculate V.A.T AT 15% OF A TOTAL.

lets say there was £120 with V.A.T all ready included how would i calculate
the V.A.T IN THE £120.

any help would be greatly appreciated and i thank you inadvance for your
response.

paul.

 

[David Biddulph]

Hence, if you want it in one step, VAT_Amount =120*15%/(1+15%)
Change the 15% to the VAT rate applicable in your case.

 

[Guest]

****THANK YOU THANK YOU****
thank you a million times for the detailed reply from both post's.
i'll try to do a macro with it.
many thanks.
paul.