Skip to main content

Hello!


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:


SWITCH(

   {Indicator},

   1, "A",

   2, "B",

   3, "C",

   4, "D",

   5, "E",

   6, "F",

   7, "G"

)

Reply


Terms & Conditions