Thanks for your prompt help. I was almost there... you've all been fantastic!

"Tyro" wrote:

Correction:

In F17 put this formula =IF(E17="V",G17*17.5%,IF(E17="E",0,"?"))

Tyro

"Tyro" wrote in message
. net...
In G17 put this formula =IF(E17="V",17*17.5%,IF(E17="E",0,"?"))
You don't state what to put in G17 if E17 is not a V or an E so I put a ?

Tyro

"Essjay" wrote in message
...
Can anyone help with syntax for an IF formula as under:
If E17=E (for exempt) then F17=$0.00 but
If E17=V (for VAT) then F17=G17*17.5%
I have an invoice on which some items are taxable and some not. If I put
the E or V letter in Column E, then I want it to return either a zero
value
or to calculate the tax in column F on Column G at 17.5%. Is this
possible?

e.g. A B - D E F G
Qty. Desc. E $0.00 200.00
Qty. Desc. V $147.00 840.00

Any help much appreciated.