How to add an and/or statement into a sheet formula

I'm a total noob when it comes to formulas and I was hoping someone could assist me with figuring out how to add an "and/or" portion into this formula:

=IF(AND([End Date]3 < TODAY(), NOT(Status3 = "Complete")), 1, 0)

Within the "Complete" portion I would like an "and/or" statement for "Cancelled". So that the "At Risk" column will not be flagged if the date isn't past due, or if the "Status" column is "Complete" or "Cancelled".

Find more posts tagged with

Accepted answers

Sameer Karkhanis

=IF(AND([End Date]@row < TODAY(), OR([Status]@row = "Complete", [Status]@row = "Cancelled" )), 0, 1)

All comments

Sameer Karkhanis

=IF(AND([End Date]@row < TODAY(), OR([Status]@row = "Complete", [Status]@row = "Cancelled" )), 0, 1)

MKuhns

Worked like a charm! Thank you Sameer!

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.