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

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.

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

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

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

For example, you can’t enter a value like $1,000 in currency format, because dollar signs are used as absolute reference indicators and commas as argument separators in formulas. To avoid …

To fix this, check the formula syntax of the function you're using and enter all required arguments in the formula that returns the error. This might require going into the Visual Basic Editor (VBE) …