=if using cells with % or text

  • Thread starter Thread starter spudsnruf
  • Start date Start date
S

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.
 
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
 
Brilliant. Thanks. Appreciate it.

Conan Kelly said:
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
Click to expand...
 
Back
Top