topic How to use IF / AND condition with logical OR formula in Workato Pros Discussion Board

How to use IF / AND condition with logical OR formula

DanM — Mon, 20 May 2024 12:26:10 GMT

Hi, I'd like to test IF variable a is equal to something AND variable b is either equal to value 1 OR value 2.

I've set up the IF condition similar to below, but can't seem to get the IF condition to evaluate true when variable b is equal to value 2. I can use a more drawn-out set of nested IFs, but I wondered if anyone can help me work out what I'm doing wrong?

IF condition:

IF evaluates false when variable b is equal value 2:

Cheers,

Dan.

Re: How to use IF / AND condition with logical OR formula

gary1 — Mon, 20 May 2024 14:36:55 GMT

You can do it all in a single conditional like this:

##IF variable a is equal to something AND variable b is either equal to value 1 OR value 2 variable_a == something && (variable_b == value1 || variable_b == value2)

Re: How to use IF / AND condition with logical OR formula

DanM — Mon, 20 May 2024 14:45:53 GMT

Thanks Gary, that works perfectly!