Debugging Your Formulas
When you share a workbook with your colleagues, some of the values in that workbook might change rapidly as new data is entered. For example, workbook data probably will change quickly if you are evaluating stock prices. Stock market values change frequently, so your data will as well. You can monitor the value in a cell even while youâre using another workbook by setting a watch. When you set a watch, the values of the cells youâre monitoring appear in the Watch Window.
Another way you can monitor your data is to check the result of part of a calculation using the Evaluate Formula dialog box. When you click the Evaluate Formula button, Excel displays the formula in the active cell and the subtotal for part of the calculation. ...
Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
