Microsoft Office Tutorials and References
In Depth Information
Finding and correcting errors in calculations
On the Formulas tab, in the Formula Auditing group, click Remove Arrows to hide
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
Click cell D21 .
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 .
Click Evaluate three times to step through the formula’s elements, and then click
Close to close the Evaluate Formula dialog box.
In the Watch Window , click the watch in the list.
Click Delete Watch to erase the watch.
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.