
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 12, 2023 12:01 AM
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?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 12, 2023 12:33 AM
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"
)
