Hi
Presumably you have a field where you are entering the VAT Code for the
transaction.
In the UK valid codes would "S", "L", "Z", "E", "O" with rates of 17.5%,
5%, 0%, 0%, 0% respectively.
If you are wanting to do the calculation on a line by line entry on your
invoice, and assuming Column C contains your Item Value, and column D
the appropriate VAT rate (letter), then in cell E2
=IF(D2="S",C2*17.5%,IF(D2="L",C2*5%,C2)) to show just the VAT amount or
=IF(D2="S",C2*1+17.5%,IF(D2="L",C2*1+5%,C2)) to show the amount uplifted
by the appropriate VAT percentage.
If you are just showing the VAT as a total at the bottom of the invoice,
and assuming the values are in the range C2:C20, with VAT code in
D2
20, then
=SUMIF(D2
20,"S",C2:C20)*17.5%+SUMIF(D2
20,"L",C":C20)*5%
--
Regards
Roger Govier
"(e-mail address removed)" <
[email protected]>
wrote in message