calculation for vatious vat rates not working 1

[michellefettes]

I am having a blonde moment

this is the formula i put in but it works if just have 2 poss results say 17.5% and 5% but if i put in a 3rd it will not work.

if {Products.VATCode}= 1 then 17.5 or if {Products.VATCode}= 2 then 5 else 0


help me please

 

[e11a]

Try this

if {Products.VATCode}= 1 then 17.5
else if {Products.VATCode}= 2 then 5
else 0

 

[michellefettes]

What a difference an else makes thanks a lot you are a star!