Simplify debugging formulas with the F9 key

- [Voiceover] When you work with certain formulas,…sometimes you recognize that a result is just dead wrong.…It's way off.…On this worksheet called debug values, I've zoomed in.…We're looking at cell D13.…I know that answer is wrong.…I'm not sure why it's about half of what it should be,…so I'm going to edit this.…Now, I can do this in the formula bar…or, maybe a little better, right on the cell itself.…Because I've zoomed in so much, I'll double click the cell,…and do the editing in here.…Now, what I'd like to be able to do…is to highlight portions of this…to see what a portion of it is equal to.…

If I highlight this calculation right here…and find out what it's equal to,…maybe that will help me figure out what's going on…or it might not.…I'm not sure, but I've got it highlighted.…I'll press the function key F9,…and that's as if to say, throw away the formula…and show me the result for just the highlighted portion…of the formula.…So, function key F9 brings me this.…Now, maybe that tells me immediately,…oh, yeah, I see what's going on.…