Multiple if statements

Roos · 10/27/21

I am receiving an unparseable error and I don't understand why. I have two different if statements. They work individually.

=IF([Working days until due date]@row > 0; "Red")

=IF([Working days until due date]@row < 0; "Green")

But when I combine them it won't work:

=IF([Working days until due date]@row > 0; "Red"); IF([Working days until due date]@row < 0; "Green")

Can anybody help me out?

Bassam Khalil · 10/27/21

Hope you are fine, please try the following formula:

=IFERROR(IF([Working days until due date]@row >= 0, "Red", 
IF([Working days until due date]@row < 0, "Green")), "")

the following screenshot shows the result:

Bassam Khalil · 10/27/21

Please accept my answer. Iferror is used to avoid any unexpected results because if bad inputs

Roos · 10/27/21

The third one I would like to add is: =IF(AND([Working days until due date]@row > 0; [Working days until due date]@row < 10); "Yellow")

Bassam Khalil · 10/27/21

Hope you are fine, please try the following formula:

=IFERROR(IF([Working days until due date]@row >= 0, "Red", 
IF([Working days until due date]@row < 0, "Green")), "")

the following screenshot shows the result:

Roos · 10/27/21

This worked thank you so much.

Could you explain what the iferror does?

Bassam Khalil · 10/27/21

Please accept my answer. Iferror is used to avoid any unexpected results because if bad inputs

Best Answers