Another way to get and use slicer values in formulas

Back in June, Kasper posted a trick which lets you detect a user's selection in a slicer, and use that in a PowerPivot measure. That's a very useful trick, one that we employ all the time at Pivotstream.

But sometimes, that is overkill. Sometimes, you just want to grab a slicer's selected value and use it in an Excel formula, right there in the sheet. Here is the simplest method we have discovered so far: