Need help with an IF Statements with multiple ORs and an AND

Hi. I need to write an IF statement where if the Review column has one of the following: Review Complete, Reviewed - Not applicable, Do not include, Reviewed - Not applicable, send feedback

AND

the COMM Review column has the following: COMM Review Complete

If both the Review Column has one of the 3 options AND the COMM Review column has COMM Review Complete, then enter "All Reviews Complete" in the All Reviews Complete column.

This is the formula I wrote, but I'm getting a unparseable error:

=IF((AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback")), IF([COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " "))

If neither of the conditions are fullfilled, then leave the All Reviews Complete column blank.

Thoughts?

Thanks,

Adrienne

Find more posts tagged with

Sheets

Formulas

Accepted answers

L_123

Sorry. went a little fast on that one.

IF(AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback"), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " ")

All comments

L_123

IF((AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback"), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " "

Give that a try

Office of the Medical Director

Hi L_123,

I tried the formula you suggested, but there were a few missing parenthesis. So this is the formula I used with the parenthesis:

=IF((AND(OR([Review Complete]@row = "Review Complete", [Review Complete]@row = "Reviewed - Not applicable, Do Not Include", [Review Complete]@row = "Reviewed - Not applicable, send feedback")), [COMM Review Complete]@row = "COMM Review Complete"), "All Reviews Complete", " ")

Unfortunately, I still am receiving an #unparseable error.

Thanks,

Adrienne

L_123

Sorry. went a little fast on that one.

Office of the Medical Director

That worked! Thanks!!!

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.