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")
What can i add to this formula to hide the error message when cell refernces aren't in the cell? I tried adding if(c4=0,"", then your formula), but it messes thing up. Thanks again in advance.
- use IFERROR(your formula here,"")
Why would you calculate a formula when there is nothing to calculate?
=IFERROR(Your_Formula,"")
