spudsnruf,

In cell A3 enter:

=If(A1="S",A2*0.175,0)

Now that would calculate the amount of tax (the amount that needs to be
added to the subtotal).

If you want, you can calculate the total like this:

=If(A1="S",A2*1.175,A2)

HTH,

Conan




"spudsnruf" wrote in message
...
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.