Is it posibble to have If(Isblank) return a yes, no, NA?

ColA will have a date or NA. ColB will have a date. I would like Col C to be blank if ColA is blank, =Yes if ColB is <=ColA, =No if ColB is >ColA, and NA if ColA is NA

Is this possible??

I get this far, but not sure how to autmate the NA

=IF(ISBLANK([ColA]@row), "", IF([ColA]@row <= [ColB]@row, "yes", "no"))

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @north

Since your ColA isn't a date only column, the formula needs to verify that dates are in the cell in order to 'do the math' of less than or greater. Try the formula below:

=IF(AND(ISDATE(ColA@row), ISDATE(ColB@row), ColB@row <= ColA@row), "Yes", IF(AND(ISDATE(ColA@row), ISDATE(ColB@row), ColB@row > ColA@row), "No", IF(ColA@row = "NA", "NA")))

Will this work for you?

Kelly

All comments

Kelly Moore

Hey @north

Since your ColA isn't a date only column, the formula needs to verify that dates are in the cell in order to 'do the math' of less than or greater. Try the formula below:

=IF(AND(ISDATE(ColA@row), ISDATE(ColB@row), ColB@row <= ColA@row), "Yes", IF(AND(ISDATE(ColA@row), ISDATE(ColB@row), ColB@row > ColA@row), "No", IF(ColA@row = "NA", "NA")))

Will this work for you?

Kelly

north

That did the trick thank you!

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.