VAT Formula for SAGE: IF cell A1 contains the text T1, and cell A2 has a value of 100.00, then A3 =A2/100*20

also if A1 contains the text T9, and cell A2 has a value, then A3=0 zero.

Hello All, I'm new, I have tried searching but can not find anything.

I need a formula for when I'm entering sales invoices onto a spreadsheet that the correct VAT element is displayed at the moment I'm having to type them in and wondered if there was a quick fix to my problem. Please help if you can.

Kind regards

MrT0PP5