How to use logical operators in "If -> then -> else" column?

Ask for Help
1

How to use logical operators in “If → then → else” column?

Example:

if → Column 1 is true AND Column 2 is true → then column 3 = true

or:

if → Column 1 is true OR Column 2 is true → then column 3 = true

At the moment I’m only able to make individual “if/else” relationships, with simple logic, not getting the expected result because I can’t use logical operators.

2

Well, column 3 would be your IF column. You can’t use an IF column to set a value in another column.

The IF column returns and displays the output of the first condition that results in a true comparison.

To structure your two examples above:

First example with an AND condition:
IF column 1 IS NOT true THEN false
ELSE IF column 2 IS NOT true THEN false
ELSE true

Second example with an OR condition:
IF column 1 IS true THEN true
ELSE IF column 2 IS true THEN true
ELSE false