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.
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,"")