Malformed If Statement

[garretwalters12]

IF [ST]='NY' THEN "NYC"

I am receiving a malformed if statement error with the above formula. Can you explain why this is and how can I correct?

[kat]

Hi @garretwalters12

You need to finish your IF statement by adding an else and an endif.

IF c THEN t ELSE f ENDIF

https://help.alteryx.com/2018.2/Reference/Functions.htm

Hope that helps!

[Lund · Accepted solution]

IF [ST]='NY' THEN "NYC" else [ST] endif

[WillTravelForData · Accepted solution]

Here is the formula that I would use: