Forum Discussion

nmlynch's avatar
nmlynch
Brass Contributor
Jan 19, 2024
Solved

Combining IF, AND and OR functions - need some guidance

Hi - trying to combine some functions to produce a result. Having no luck. Attached is a spreadsheet.   I need to determine if a Pain Score at either a Screening Visit or a Baseline Visit is an eli...
  • Rodrigo_'s avatar
    Jan 19, 2024

    nmlynch 

    Here's the formula:

    =IF(OR(B26="Screening", B26="Baseline"), IF(AND(C26>=40, C26<=80), "Eligible", "Not Eligible"), "Not Applicable")

     

     

Resources