To search for errors:
Click the Error Checking button on the Formula Auditing toolbar
The Error Checking dialog box opens
To correct the error:
Excel update the formula automatically
Click the Update Formula to Include Cells button
Sunday, March 8, 2009
Locating Suspect Formulas
A suspect formula returns a value, but the wrong value.
To search for errors:
Click the Error Checking button on the Formula Auditing toolbar
The Error Checking dialog box opens
To correct the error:
Excel update the formula automatically
Click the Update Formula to Include Cells button
To search for errors:
Click the Error Checking button on the Formula Auditing toolbar
The Error Checking dialog box opens
To correct the error:
Excel update the formula automatically
Click the Update Formula to Include Cells button
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment