CODEWITHSUNDEEP
excelexcel-formula
curiousgeorge
curiousgeorge

Reputation: 619

Easily seeing values of subsets of excel formula

Often I have large excel formulas with 6+ layers of nesting. When debugging it would be very convenient to see the value of a subset of the formula e.g. see what one argument to OR is evaluating to. Is there an easy way to do this?

Upvotes: 1

Views: 56

Answers (1)

Charles Williams
Charles Williams

Reputation: 23540

One way is to select the subset of the formula within the formula bar and press F9. But be careful to press Escape to revert to the original formula - otherwise you overwrite it.

Note this does not work well with formula subsets that return large arrays.

Upvotes: 2

Related Questions