The Magic of IF(VALUES())

"I'm Dan Marino, and IF() anyone knows the VALUE() of protection, it's me."

Boom! An Ace Ventura quote finally graces the blog. Yes folks, that fine work of American cinema did indeed feature Dan Marino reprising his real-world ad for Isotoner.

But more importantly, I wanted to revisit this little two-function combo: IF(VALUES()). I've covered it before a few times, but generally in the context of covering something else.

And since this is one of my favorite techniques, I think it deserves its own dedicated post. A series of posts, actually. Let's dig in.