IF THEN ELSE - multiple condition

Ask for Help
1

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

2

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
3

One IF column.

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

6 Likes