Formula Triggers & Absurd Results?

QUESTION Rowka asked “how do I make this formula smaller?” =IF(AND(E11>=K7,E11=K7,F11=K7,G11” jazz. Our trigger will be: If there are fewer than 3 readings, then don’t calculate anything. COUNTA is the function that counts non-empty cells....
#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...