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

In Partial and Manual Calculation modes, Excel denotes a stale cell with a strikethrough to alert users that its value is not yet reliable and should be recalculated to account for recent changes.

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

Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE (A1:A20) returns the average of those numbers.

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

Learn about the implicit intersection operator (@), which returns a single value using logic known as implicit intersection. The implicit intersection operator (@) may return a value, single cell …

Text can be in any of the constant number, date, or time formats recognized by Microsoft Excel. If text is not in one of these formats, VALUE returns the #VALUE! error value.

This article describes the formula syntax and usage of the N function in Microsoft Excel. Description Returns a value converted to a number. Syntax N (value) The N function syntax …

Spilled array formulas aren't supported in Excel tables. Try moving your formula out of the table, or converting the table to a range (select Table Design > Tools > Convert to range).