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...
#5 of the Top 5 Excel Functions to Know: SUMIFS

#5 of the Top 5 Excel Functions to Know: SUMIFS

And here we are at the 5th of the Top 5 Excel Functions to Know! SUMIFS is in the Top 5 because when you’re working with numbers and need to do analysis or summaries, SUMIFS makes it so easy to see details that you need to see. We didn’t always have this....
#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...

#3 of the Top 5 Excel Functions : AND OR (Virtual Insanity)

# 3 In our Top 5 Excel Functions, the Operators AND & OR Excel AND and OR functions are fairly straightforward. In this post, we see cover details and warnings. And we wrap up with a Thought Exercise rather than examples. So, let’s hit it! If VLOOKUP were a...
Follow

Get every new post delivered to your Inbox

Join other followers: