Multiple Dropdown values in If statement

Platform discussions
, ,
1

Hi everyone,

I am managing products on a board and want to calculate revenue for specific products. I use a dropdown for the different products we have and want to use a formula to say

IF Product is EITHER, a,b,c or d - times column x by column y

is there a way I can select multiple values in an if statement so I dont have nest different IF statements.

Thanks in advance!!

2

Here are 2 ways:

  • SWITCH({Product#Labels}, “a”, {x} * {y}, “b”, {x} * {y}, “c”, {x} * {y}, “d”, {x} * {y}, “none”)
  • IF(OR({Product#Labels}=“a”, {Product#Labels}=“b”, {Product#Labels}=“c”, {Product#Labels}=“d”), {x}*{y}, “none”)
2 Likes
3

Amazing, this has solved my problem. Thanks for the really quick and easy reply :slight_smile:

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.