Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula (IF + OR)

Topic Labels: Formulas
900 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Marika_Vallier
6 - Interface Innovator
6 - Interface Innovator

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