Microsoft Office Tutorials and References
In Depth Information
9. Click Next .
Excel displays a message box indicating that there are no more errors in the
10. Click OK .
The message box and the Error Checking dialog box close.
11. On the Formulas tab, in the Formula Auditing group, click the Error Checking
arrow, and then in the list, click Trace Error .
Blue arrows appear, pointing to cell D21 from cells C12 and D19. These arrows
indicate that using the values (or lack of values, in this case) in the indicated cells
generates the error in cell D21.
12. On the Formulas tab, in the Formula Auditing group, click Remove Arrows .
The arrows disappear.
13. In the formula box, delete the existing formula, type =C12/D20 , and press Enter.
The value 14% appears in cell D21.
14. Click cell D21 .
15. On the Formulas tab, in the Formula Auditing group, click the Evaluate Formula
The Evaluate Formula dialog box opens, with the formula from cell D21 displayed.
16. Click Evaluate three times to step through the formula’s elements, and
then click Close .
The Evaluate Formula dialog box closes.