LONG Nested IF statement

[mingy22]

Hi Community,

I am trying to use this nested IF statement:

IF [Month] = "1" THEN "January"
ELSEIF [Month] = "2" THEN [F7] ="February"
ElSEIF [Month] = "3" THEN [F7] = "March"
ElSEIF [Month] = "4" THEN [F7] = "April"
ElSEIF [Month] = "5" THEN [F7] = "May"
ElSEIF [Month] = "6" THEN [F7] = "June"
ElSEIF [Month] = "7" THEN [F7] = "July"
ElSEIF [Month] = "8" THEN [F7] = "August"
ElSEIF [Month] = "9" THEN [F7] = "September"
ElSEIF [Month] = "10" THEN [F7] = "October"
ElSEIF [Month] = "11" THEN [F7] = "November"
ELSEIF [Month] = "12" THEN [F7] = "December"

ELSE [Month] ="n/a"

ENDIF

within the Formula tool to create a new column taking the month # value from another column and changing it to written month. But I am getting an error that my IF statement is incorrect and I have tried everything. Thanks for your help!

[ivoller]

If you are trying to set [F7] based on this formula you should use something like

IF [Month] = "1" THEN "January"
ELSEIF [Month] = "2" THEN "February"
ElSEIF [Month] = "3" THEN  "March"
ElSEIF [Month] = "4" THEN  "April"
ElSEIF [Month] = "5" THEN  "May"
ElSEIF [Month] = "6" THEN  "June"
ElSEIF [Month] = "7" THEN  "July"
ElSEIF [Month] = "8" THEN  "August"
ElSEIF [Month] = "9" THEN  "September"
ElSEIF [Month] = "10" THEN  "October"
ElSEIF [Month] = "11" THEN  "November"
ELSEIF [Month] = "12" THEN  "December"

ELSE [Month] ="n/a"

ENDIF

Also check out SWITCH statement for another way.

[DiganP · Accepted solution]

@mingy22 make sure your formula is set up correctly.

You do not need [F7] = in all the statements. Just put the Output column as F7. Hope that helps.

[mingy22]

Thank you so much!