IF AND or statement

[jaolvera]

Hello I need assistance with a formula that would produce a "yes" or "no" response, if cells N,R,V or Z="COVID PCR" "RSV PCR" or "Resp.Panel" and cells O,S,W or AA="Positive" 

[#2]

Hi @jaolvera ,

If I understood correctly, here is a sample that can help you. It is basically catching the conditions that you mentioned and validating it in an IF statement. To make your life easier (as the name of the tests may change in the future), they are stored in specific cells in a validation tab.

Please, let me know if it helps and, if not, please add a little more context on your problem.