#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 …

This topic provides help for the most common scenarios for the #VALUE! error in the IF function.

This topic provides help for the most common scenarios for the #VALUE! error in the AVERAGE or SUM functions.

This topic provides help for the most common scenarios for the #VALUE! error in the SUMIF/SUMIFS functions.

Use a formula to subtract dates or Add or subtract time correctly to avoid negative date or time value results. Change negative formula results that are formatted as dates or times to a …

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

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.

Jun 22, 2000 · This topic provides help for the most common scenarios for the #VALUE! error in the DATEVALUE function.

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.

Jun 22, 2000 · This topic provides help for the most common scenarios for the #VALUE! error in the DAYS function.