Multiple if statements

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?

Find more posts tagged with

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.