Evaluate a nested formula one step at a time--looking for shortcut command that does the same?

10/24/2015

Solution1: 

Source: https://support.office.com/en-us/article/Evaluate-a-nested-formula-one-step-at-a-time-59a201ae-d1dc-4b15-8586-a70aa409b8a7

1. On the Formulas tab, in the Formula Auditing group, click Evaluate Formula.
   
2. Click Evaluate to examine the value of the underlined reference. The result of the evaluation is shown in italics.
3. If the underlined part of the formula is a reference to another formula, click Step In to display the other formula in the Evaluation box. Click Step Out to go back to the previous cell and formula NOTE The Step In button is not available for a reference the second time the reference appears in the formula, or if the formula refers to a cell in a separate workbook.
4. Continue until each part of the formula has been evaluated
5. To see the evaluation again, click Restart.
6. To end the evaluation, click Close.

NOTES

• Some parts of formulas that use the IF and CHOOSE functions are not evaluated, and #N/A is displayed in the Evaluation box.
• If a reference is blank, a zero value (0) is displayed in the Evaluation box.
• The following functions are recalculated each time the worksheet changes, and can cause the Evaluate Formula to give results different from what appears in the cell: RAND, AREAS, INDEX, OFFSET, CELL, INDIRECT, ROWS, COLUMNS, NOW, TODAY, RANDBETWEEN.

Solution 2:

Select cell with formula, go to each section of the formula that means select section 1 in the formula, once selected to to 'Formula' in menu bar and click evaluate. Do this every time, that way it will show you what section in formula is producing.