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.
Both formulas work fine.
I can't see your formula in the screenshot.
What must i do so that the cells are automatically highlighted based on the results? Thanks again!
- You could use conditional formatting for that.
- Thanks Detlef. I will try again.
I only took a screenshot of the spreadsheet cause I deleted the initial formula I tried using.
