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...
excel
Excel on Mac
Formulas and Functions
  • Rodrigo_'s avatar
    Rodrigo_
    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")

     

     

Rodrigo_'s avatar
Rodrigo_
Iron Contributor
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")

 

 

  • nmlynch's avatar
    nmlynch
    Brass Contributor
    Jan 21, 2024
    Thank you Rodrigo_. This worked perfectly! Upon studying your formula, I suddenly saw my errors. Your answer taught me something about these functions. Thanks!

Resources