Hi there!
I am trying to create a formula that looks at an entry (single select) and if that entry is = A, B or C say "Blabla" and if it says anything else say "Haha".
I have hence tried to nest OR() into IF() as followed:
IF(entry=OR("A", "B","C"), "Blabla", "Haha")
I am not shown any error but the formula result is wrong (It says "Haha" when it should say "Blabla').
Any thoughts?
Hi @Marika_Vallier
Let's try the formula "OR("A", "B", "C")". The result should be 1.
With your formula, "Blabla" would only be obtained if "Entry=1".
It can be written in various ways, but if the SWITCH function is used, it will look like this.
IF(
SWITCH(ENTRY,
"A",1,
"B",1,
"C",1,
0
),
"Blabla",
"hal"
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.