Microsoft Office Tutorials and References
In Depth Information
Correcting Calculation Errors
Correcting Calculation Errors
When Excel finds a possible error in a calculation, it displays a green triangle in the upper
left corner of the cell. If Excel can’t complete a calculation it displays an error message,
such as “#DIV/0!” or “#NAME?. You can use the Error Options button to help you fix
the problem. In a complex worksheet, it can be difficult to understand the relationships
between cells and formulas. Auditing tools enable you to clearly determine these relation-
ships. When the Auditing feature is turned on, it uses a series of arrows to show you which
cells are part of which formulas. When you use the auditing tools, tracer arrows point out
cells that provide data to formulas and the cells that contain formulas that refer to the cells.
A box is drawn around the range of cells that provide data to formulas.
Review and Correct Errors
Select a cell that contains a green triangle in the upper left corner.
Click the Error Options button.
Click one of the troubleshooting options (menu options vary depending on the
• To have Excel fix the error, click one of the available options specific to the
• To find out more about an error, click Help on this Error .
• To evaluate the formula, click Show Calculation Steps .
• To remove the error alert, click Ignore Error .
• To fix the error manually, click Edit in Formula Bar .
• To enable background error checking, specify an error color, or reset ignored
errors, click Error Checking Options .
Search JabSto ::

Custom Search