IF AND or statement

Occasional Contributor

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" 




1 Reply

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.