Multiple if statements

Roos

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

@Roos

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

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

Roos

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

@Roos

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

This worked thank you so much.

Could you explain what the iferror does?

Bassam Khalil

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