AMPScript IF/ELSEIF seems to only work 50% of time

Question

I'm modifying an email template to check if a state value is true or not, if it is, display a specific value, otherwise, display a default message.

My code is as follows:

%%[
    IF @Ship_State == "CO" THEN
        SET @TaxDisplay = "Not collected"
    ELSEIF @Ship_State == "LA" THEN
        SET @TaxDisplay = "Not collected"
    ELSEIF @Ship_State == "VT" THEN
        SET @TaxDisplay = "Not collected"
    ELSE
        SET @TaxDisplay = Format([OrderTax],"$#,#.00")

]%%
%%[ENDIF]%%

%%=v(@TaxDisplay)=%%

I've checked the data of @Ship_State, and it is always a two letter abbreviation with capital letters. So it's not a legitimate data mismatch issue.

When testing the email, seemingly half the time when ship state is CO, LA, or VT it either correctly outputs "Not collected" or it doesn't when it should.

Answer 1

I think the code could be written better (i.e making the logic tighter).

Try this:

%%[
    IF ( @Ship_State == "CO" OR @Ship_State == "LA" OR  @Ship_State == "VT" ) THEN
        SET @TaxDisplay = "Not collected"
    ELSE
        SET @TaxDisplay = Format([OrderTax],"$#,#.00")
    ENDIF   
]%%

%%=v(@TaxDisplay)=%%