Select Page

## What Elements Are In a Strong Spreadsheet? (Contiguous Data)

QUESTION What are the elements of a strong spreadsheet? This question came from Judie Knoerle of Red Cup Presentations. Judy and I attend a networking group and I spoke highly of a friend’s spreadsheet. My friend had asked me to look at her spreadsheet and...

## 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

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 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