Need a fix for IF AND/OR formula

keesuri25

IF(AND([Phase]@row = "COMPLETED”, OR Hand-off]@row = "N/A", [Hand-off]@row = 0),0,1)

So for Phase set to completed and where Hand-off is N/A or 0 or blank .. need to set 0, or else 1.

Or For Phase set to completed, where Hand-off is 1 - put 1.. for everything else put 0 ..

Find more posts tagged with

Accepted answers

All comments

Mike TV

@keesuri25

=IF(AND(Phase@row="COMPLETED", [Hand-off]@row=1), 1, IF(AND(Phase@row="COMPLETED", OR([Hand-off]@row="N/A", [Hand-off]@row=0, ISBLANK([Hand-off]@row))), 0, 1)

This may or may not work because your first conditions you say "or else 1" and your second conditions you say "for everything else put 0". Very confusing.

Jeff Reisman

@keesuri25 You are close, just a little syntax fix and a bit more criteria needed.

IF(AND([Phase]@row = "COMPLETED”, OR([Hand-off]@row = "N/A", [Hand-off]@row = 0, ISBLANK([Hand-off]@row))), 0, 1)

Logic: If Phase equals COMPLETED and Hand-off is either "N/A", 0, or blank, set the cell to 0; otherwise, set the cell to 1. (The OR statement containing the options for Hand-off has to be enclosed within the AND statement.)

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.