Finding and Correcting Errors in Calculations

You can find errors by clicking on the Error button that appears next to it. You can also find errors by tracing the cell's precedents. You can also trace the cells dependents. Another way to find errors is by using the Error Checking dialog box. You can also find and correct the errors by using the evaluate formula dialog box. You can use the Watch window to display the values in a cell.