Nested IF and SWITCH driving me up the wall!


I’m trying to use the nested IF function to return a specific piece of text per code that I enter (7 codes in total). I have tried to use both IF and SWITCH, and they seam to work for the first one or two and then I can’t get any further.

For example, these are the conditions I would like to have met:

IF{Indicator}=1, “A”
IF{Indicator}=2, “B”
IF{Indicator}=3, “C”
IF{Indicator}=4, “D”
IF{Indicator}=5, “E”
IF{Indicator}=6, “F”
IF{Indicator}=7, “G”

The letters (A-G) are just substitutes for text I would like to include. It’s one sentence per IF function - could it be a length issue?

I don’t know of any character limit for formulas so I don’t think that would be the issue. A SWITCH() function would look like this:

   1, "A",
   2, "B",
   3, "C",
   4, "D",
   5, "E",
   6, "F",
   7, "G"
1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.