Trying to evaluate cells C7:C11 to determine if the values are within the high/low limits provided in cells B16 and B17. I can get the formula to work for a single cell but need to evaluate all cells against these limits to return a single PASS/FAIL result. This is the formula that works for the single cell (C7 in this case).
=IF(AND($B18<=C7,$B19>=C7),"PASS","FAIL")
I have tried using C7:C11 and nesting same for each additional cell but just cant get it to work. Thanks for your help!!
Bookmarks