cancel
Showing results for 
Search instead for 
Did you mean: 

How to use AND Operator with IF condition in Formula Mode

zaygum
Deputy Chef I
Deputy Chef I

Hi,

I am trying to use an AND operator with IF ELSE in the Formula mode in Workato.

Trying to do something like:

IF condition1=TRUE   AND   Condition2=True
Value

Can someone please assist on this.

Thanks

 

1 ACCEPTED SOLUTION

gary1
Executive Chef II
Executive Chef II

You can use a "ternary operator", which is basically an "if" statement. It has this syntax:

logical_condition ? result_when_true : result_when_false

Example:

1 == 1 ? "true!" : "false!" ## >> "true!"

The AND operator is "&&" and the OR operator is "||"

Example:

1 == 1 && 0 == 1 ? "true!" : "false!" ## >> "false!"

 

View solution in original post

1 REPLY 1

gary1
Executive Chef II
Executive Chef II

You can use a "ternary operator", which is basically an "if" statement. It has this syntax:

logical_condition ? result_when_true : result_when_false

Example:

1 == 1 ? "true!" : "false!" ## >> "true!"

The AND operator is "&&" and the OR operator is "||"

Example:

1 == 1 && 0 == 1 ? "true!" : "false!" ## >> "false!"