How to Check Formulas for Errors in Excel 2007
When you create formulas, you can embed a formula within another formula. Because there are so many steps involved when you do this, trying to ascertain the accuracy of your results may be difficult. One option that is available to you is the Evaluate Formula dialog box. You can use this to check the result [...]