I see #VALUE! instead of content in some cells

Cause: The formula is missing a required argument.

Solution:    Make sure that the formula or function is correct for the required operand or argument, and that the cells that are referenced by the formula contain valid values.

Excel cannot translate the text into the correct data type. For example, if cell A5 contains a number and cell A6 contains the text "Not available", the formula =A5+A6 will return the error #VALUE!. Use the SUM function in the formula as follows to add the two values (the SUM function ignores text): =SUM(A5:A6)

Cause: The array formula is entered incorrectly.

Solution:    Use the following procedure to enter the array formula.

• Select the cell or range of cells that contains the array formula, press CONTROL + U to edit the formula, and then press + RETURN .

Cause: A cell reference, formula, or function is entered as an array constant.

Solution:    Make sure that the array constant does not contain a cell reference, formula, or function.

Array constants cannot contain cell references, columns or rows of unequal length, formulas, functions, or the special characters dollar sign ($), parentheses (()), or percent sign (%).

Cause: A range of values are supplied to an operator or function that requires a single value.

Solution:    Change the formula to reference a single value.

1. Select the cell.

2. On the Formulas tab, under Function, click Formula Builder.

   

3. Edit the formula in the Arguments section of the Formula Builder window.

Solution:    Change the range reference to include either the same row or the same column that contains the formula.

1. Select the cell.

2. On the Formulas tab, under Function, click Formula Builder.

   

3. Edit the formula in the Arguments section of the Formula Builder window.

Cause: A matrix that is not valid is used in one of the matrix functions, such as MINVERSE, MMULT, and MDETERM.

Solution:    Make sure that the dimensions of the matrix are correct for the matrix function arguments.

1. Select the cell.

2. On the Formulas tab, under Function, click Formula Builder.

   

3. Edit the formula in the Arguments section of the Formula Builder window.

See also

Hide error values and error indicators