Help

Formula (IF + OR)

Topic Labels: Formulas
389 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Marika_Vallier
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Reply 1
Sho
11 - Venus
11 - Venus

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"
)