Troubleshooting Excel 2010 Formulas

Sorted by:  

Deciphering Error Values in Excel 2010 Formulas

You can tell right away that an Excel 2010 formula has gone haywire because instead of a nice calculated value, you get a strange, incomprehensible message. This weirdness, in the parlance of Excel 2010 [more…]

Understanding Excel 2010's Formula Error Values

If Excel 2010 can't properly calculate a formula that you enter in a cell, the program displays an error value in the cell as soon as you complete the formula entry. Excel uses several error values, all [more…]

Understanding Excel 2010's Formula Auditing Tools

Excel 2010 offers some effective formula-auditing tools for tracking down the cell that's causing your error woes by tracing the relationships between the formulas in the cells of your worksheet. By tracing [more…]

How to Trace Precedents and Dependents in Excel 2010 Formulas

Excel 2010 formulas may contain precedents and may serve as dependents to other formulas. Precedents are cells or ranges that affect the active cell's value. [more…]

How to Check For and Evaluate Errors in Excel 2010 Formulas

The Evaluate Formula dialog box in Excel 2010 walks you through the steps used in calculating a result from a formula. This helps locate errors in formulas that are long or have precedents. For example [more…]

Dealing with Circular References in Excel 2010 Formulas

A circular reference occurs when a cell in an Excel 2010 worksheet refers to itself, whether directly or indirectly. For example, if =100+A2 is entered into cell A2, then a direct circular reference has [more…]

Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software
Win $500. Enter Now.