IF THEN ELSE - multiple condition

Hi all,

I am working with two columns with the function IF THEN ELSE.

IF A > 0, and at the same time B > 0, then enter value X.

How to set it up?

Thank you,

you need two IF-ELSE columns to mark 1 if true… then a math column to add these two… then another IF-ELSE to check if the math column = 2…
or you can multiply these two and check if the result is > 0

1 Like

One IF column.

IF A <= 0 Then ‘’
ElseIF B <= 0 Then ‘’
Else X