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!
Solved! Go to Solution.
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.
@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.
Thank you so much!