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

Office of the Medical Director

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

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", " ")

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.

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", " ")

Office of the Medical Director

That worked! Thanks!!!