How to use logical operators in “If → then → else” column?
if → Column 1 is true AND Column 2 is true → then column 3 = true
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.
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
Second example with an OR condition:
IF column 1 IS true THEN true
ELSE IF column 2 IS true THEN true
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.