IF Formula Unparseable
I’ve read through many posts to include the formula guide, but I cannot figure out what I’m doing on a very simple IF formula. Let’s start with the first challenge.
If a number is equal to a defined number, I want to display text. To do so, I’m using the IF function. More specifically, I want a column to display the month based on a numeric value, 1 = JAN, 2 = FEB etc.
All formulas return the result of #UNPARSEABLE. The attached screenshow shows the result of using those formulas, the Formula Guidance column shows the Formulas attempted but I’ve omitted the equal sign to display the full text of the formula. I’m sure I’m missing something simple but I cannot figure it out. Please help.
Help Article Resources
Check out the Formula Handbook template!