Value preview in formula bar.
Using Value Preview, you can see the value of each part of a formula in Excel. Just highlight the reference you are interested in, and a little box pops up that show you the value(s) in that reference. Or you can click on the parameter in the formula structure. More information and some videos showing […]