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.
I think this is better:
=IF(AND(AverageNumber>=Lower;AveregeNumber<=Upper),"Pass","Fail")
Why?