I would like to do the following :

Look at cell a1 to see if the letter in that cell is either S (for standard
VAT) or Z (for Zero Vat). Then depending on what letter is cell a1, I would
like to multiply an amount in cell a2 by either 17.5% if S or 0% if Z.