Formulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate the causes of these errors and determine …

Here’s how: Click Open in Excel and use error checking to detect errors in formulas. For news about the latest Excel Online updates, visit the Microsoft Excel blog. For the full suite of Office applications and …

This topic provides help for the most common scenarios for the #VALUE! error in the FIND/FINDB and SEARCH/SEARCHB functions.

#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and it can be …

Compare the inconsistent formula with ones before and after it, and correct any unintentional inconsistencies. When you're done, select Formulas > Show Formulas to show the calculated results …

If you want to move forward, then the following checklist provides troubleshooting steps to help you figure out what may have gone wrong. Select the headings to learn more. Note: If you're using …

If you can't find the error, select the Formulas tab, select the arrow next to Error Checking, point to Circular References, and then select the first cell listed in the submenu.

The #REF! error shows when a formula refers to a cell that's not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.

Excel shows this error when a formula or function contains numeric values that aren’t valid. This often happens when you’ve entered a numeric value using a data type or a number format that’s not …

You can use the IFERROR function to handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.