Finding and Correcting Errors in Calculations

The way to do this, is to auditing. The first thing is, to fill the cell holding the formula generating ther error with an error code (#NAME?). Then when a cell with an erroneous formula is the active cell, an Error Button appears next to it. Next click the button down arrow to display a menu with a options that has information about the error and to help you fix it. Next if the cells, identified by the tracer arrows aren't the correct cells, you can hide the arrows and correct the formula. Then hide the tracer arrows, if you have elements of a formula error as text in a dialog box. You could use the Error Checking dialog box. For, to view the error and the formula in the cell in which the error occurs, so that you can ignore or move through the error. And to display the Evaluate Formula, is much more useful for examining formulas that don't produce an error but aren't generating the result you expect. Finally, by opening the Watch Window, it displays the new results of the formula.