To fix this, change the formula so that its result is between -1*10 307 and 1*10 307. Tip: If error checking is turned on in Excel, you can select next to cell that shows the error. Select Show Calculation Steps …

When Excel shows ##### because the cell has a negative date or time value, make sure that you: Verify dates and times are positive values when you’re using the 1900 date system.

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.

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.

For other causes and solutions, see Correct a #NUM! error. #N/A error If a formula can’t find a referenced value, it returns the #N/A error. For more information, see Correct a #N/A error. #REF! …

This topic covers the common scenarios of the #VALUE! error when working in the VLOOKUP function.

Let's say that your spreadsheet formulas have errors that you anticipate and don't need to correct, but you want to improve the display of your results. There are several ways to hide error values and error …

If you're still needing help fixing this error, the following checklist provides troubleshooting steps to help you figure out what may have gone wrong in your formulas.

Custom functions that refer to more than 10,000 cells cannot be calculated in Excel for the web, and will produce this #CALC! error instead. To fix, open the file in a desktop version of Excel.

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 …