Skip to search results
PRODUCT
Office.com results
Find and correct errors in formulas
Article Find cells that have formula errors and learn general techniques for solving them. Find links to forums that offer help with specific formula errors.
Excel 2007
Evaluate a nested formula one step at a time
Article Sometimes, understanding how a nested formula calculates the final result is difficult because there are several intermediate calculations and logical tests. ...
Excel 2007
Issue: An _xlfn. prefix is displayed in front of a formula
Article Symptoms An _xlfn. prefix is displayed in front of a function in a formula. When the formula is calculated, it displays the #NAME? error value. Cause The Micros...
Excel 2007, Excel 2003
Replace a formula with its result
Article You can convert the contents of a cell that contains a formula so that the calculated value replaces the formula. If you want to freeze only part of a formula, ...
Excel 2007
Watch a formula and its result by using the Watch Window
Article When cells are not visible on a worksheet, you can watch those cells and their formulas in the Watch Window toolbar . The Watch Window makes it convenie...
Excel 2007
Remove or allow a circular reference
Article Locate and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel 2010.
Excel 2010
Correct a ##### error
Article This error indicates that a column is not wide enough to display all of its content, or that a negative date or time is used in a cell. Symptom Excel displays ...
Excel 2007
Correct a #DIV/0! error
Article Show All Hide All Excel displays the #DIV/0! error when a number is divided either by zero (0) or by a cell that contains no value. Symptom Excel displays the #...
Excel 2007
Correct a #NULL! error
Article This error occurs when you specify an intersection of two areas that do not intersect. The intersection operator is a space character between references. Sympto...
Excel 2007
Display the relationships between formulas and cells
Article When checking formulas, use the Trace Precedents and Trace Dependents commands to display the relationships between these cells and formulas.
Excel 2007
Protect or audit formulas
Article For security or privacy reasons, you may want to hide a formula from users of your worksheet. Or you may be auditing formulas and you need to see some or all of...
Excel 2007
Remove or allow a circular reference
Article Locate and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel 2007.
Excel 2007
Correct common errors in formulas
Article Show All Hide All Like a spelling checker that checks for errors in data that you enter in cells, you can implement certain rules to check for errors in formula...
Excel 2007
Find and fix a circular reference
Article Locate and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel.
Excel 2013
Didn't find what you were looking for?Search all of Office.com