Forum Discussion
Formula Help Please
I have an average number in one cell and if it falls in between 2 numbers located in 2 seperate cells i want it to read "Pass" or "Fail" if it's outside the parameters in a seperate cell.
Hello Chris
=IF(MEDIAN(AverageNumber,Lower,Upper)=AverageNumber,"Pass","Fail")
Thanks for the assist guys, but neither worked for my particular application. Here is a visual of what i'm trying to accomplish. If F4 is <H8 or >I4 it should read Q4. If it falls betrween the 2 parameters it should read Q5. Thaks again in advance.