Microsoft Office Tutorials and References
In Depth Information
Finding and correcting errors in calculations
12
On the Formulas tab, in the Formula Auditing group, click Remove Arrows to hide
the arrows.
13
In the formula box, delete the existing formula, enter =C12/D20 , and then press
Enter . The value 14% appears in cell D21 and the change is reflected in the Watch
Window.
14
Click cell D21 .
15
On the Formulas tab, in the Formula Auditing group, click the Evaluate Formula
button to open the Evaluate Formula dialog box, which displays the formula from
cell D21 .
16
Click Evaluate three times to step through the formula’s elements, and then click
Close to close the Evaluate Formula dialog box.
17
In the Watch Window , click the watch in the list.
18
Click Delete Watch to erase the watch.
19
On the Formulas tab, in the Formula Auditing group, click Watch Window to close
the Watch Window .
CLEAN UP Close the ConveyerBid workbook, saving your changes if you want to.
Search JabSto ::




Custom Search