How can I ignore a blank cell in an IF formula?

I'm calculating the workdays between two days and updating the status in a different column. How do I make the formula ignore blank cells in the Install Difference column?

=IF([Install Difference]@row >= 21, "Late Over 4 Weeks", IF([Install Difference]@row >= 11, "Late Over 2 Weeks", IF([Install Difference]@row >= 2, "Late", IF([Install Difference]@row >= 1, "On Time", IF([Install Difference]@row < 1, "Early")))))

Find more posts tagged with

Formulas

Accepted answers

All comments

Gillian C

Hi @moorejr

You want to add an if statement around the formula above to state if [Install Difference]@row is not blank, …

So your formula would be

=IF([Install Difference]@row <> "", (IF([Install Difference]@row >= 21, "Late Over 4 Weeks", IF([Install Difference]@row >= 11, "Late Over 2 Weeks", IF([Install Difference]@row >= 2, "Late", IF([Install Difference]@row >= 1, "On Time", IF([Install Difference]@row < 1, "Early", "")))))), "")

Which would give the following results

If the blanks in the Install Difference column mean the install hasn't started yet you can change the above forumula to something like

to get

Hope this helps :)

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.