V.A.T how to calculate it
 

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.

V.A.T how to calculate it
 

Try this:

Cost = Price * (1 + VAT_Rate)
Price = Cost / (1 + VAT_Rate)
Price = 120 / (1 + 0.15)
Price = 104.347826086957

VAT_Amount = Cost - Price
VAT_Amount = 120 - 104.347826086957
VAT_Amount = 15.6521739130435

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"pm_sam" wrote in message
...
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.

V.A.T how to calculate it
 

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.
--
David Biddulph

"Ron Coderre" wrote in message
...
Try this:

Cost = Price * (1 + VAT_Rate)
Price = Cost / (1 + VAT_Rate)
Price = 120 / (1 + 0.15)
Price = 104.347826086957

VAT_Amount = Cost - Price
VAT_Amount = 120 - 104.347826086957
VAT_Amount = 15.6521739130435

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"pm_sam" wrote in message
...
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.

V.A.T how to calculate it
 

****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.