Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Troubleshooting Excel 2010 Formulas

View:  
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…]

Excel Error Messages to Get to Know

If you create a formula in Excel that contains an error or circular reference, Excel lets you know about it with an error message. A handful of errors can appear in a cell when a formula or function in [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…]

Advertisement
Learning anything is easy with For Dummies eLearning!

Sign Up for RSS Feeds

Computers & Software
Win an iPad Mini! Enter to win now.

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!