=if using cells with % or text

[spudsnruf]

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.

 

[Conan Kelly]

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]

Brilliant. Thanks. Appreciate it.

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