Forum Discussion

nmlynch's avatar
nmlynch
Copper 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_
Steel 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
    Copper 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