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

  • Thread starter Thread starter chrissy
  • Start date Start date
C

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 :confused:
 
Hi
you may provide some more details:
- e,g, example data
- how do you know which rows contain VAT
 
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
 
Back
Top