Hi all,

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

Example:

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

How to set it up?

Thank you,

Monika

Hi all,

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

Example:

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

How to set it up?

Thank you,

Monika

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

6 Likes