Multiple IF Statements Along with "OR"

BrandonS4

I need to have multiple IF statements along with "OR".  I am not getting the results I wanted.  Here is what I have:

State

Western NC

Eastern NC

Central NC

West FL

South FL

I want to use to say "IF [State] = "Western NC" OR "Eastern NC" OR "Central NC" 

                                 THEN "NC"

                                 ELSEIF [State] = "West FL" OR "South FL"

                                 THEN "FL"

                                 ELSE [State]

                                 END IF

I am only getting the first value of each IF statement.  Can anyone help?

Thanks!

Jonathan-Sherman

Hi @BrandonS4,

But i would also prefer to clean the statement up a little and use the IN() function rather than repeating the column name each time:

IF [State] IN("Western NC","Eastern NC","Central NC")
THEN "NC"
ELSEIF [State] IN("West FL","South FL")
THEN "FL"
ELSE [State]
ENDIF

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan