Formula Triggers & Absurd Results?

QUESTION Rowka asked “how do I make this formula smaller?” =IF(AND(E11>=K7,E11<=N7,F11>=K7,F11<=N7,G11>=K7,G11<=N7),”PASS”,”FAIL”) Translation of the Formula: If tests 1 thru 3 are within acceptable ranges, then...
#4 of the Top 5 Functions: IFERROR

#4 of the Top 5 Functions: IFERROR

#4 in the List of Top 5 Functions: IFERROR Q:  What do an acrobat and Excel’s IFERROR function have in common? A:  An acrobat and an Excel user who employs IFERROR are both expressing: it’s risky but I know what I’m doing and I do it with elegance...