Forum Discussion

jaolvera's avatar
jaolvera
Brass Contributor
Feb 06, 2023

IF AND or statement

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" 

 

 

excel

1 Reply

  • rzaneti's avatar
    rzaneti
    Iron Contributor
    Feb 06, 2023

    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.

Resources