how do I work out the VAT on a multpl of columns?

[chrissy]

i.e. I have a spread sheet of petty cash, some of the columns have VAT
and some don't say A TO M items and column N is the VAT. what formula
do I use

 

[Frank Kabel]

Hi
you may provide some more details:
- e,g, example data
- how do you know which rows contain VAT

 

[Bill Kuunders]

this will return the total amount of vat if the amounts in column A to M are
vat inclusive.
=(SUM(A4:M4)/(112.5))*12.5

assuming the tax rate is 12.5 %

Regards
Bill K