Correct a #VALUE! error

Occurs when the wrong type of argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) or operand (operand: Items on either side of an operator in a formula. In Excel, operands can be values, cell references, names, labels, and functions.) is used.

  1. Click the cell that displays the error, click the button that appears Button image, and then click Trace Error if it appears.
  2. Review the possible causes and solutions.

Possible causes and solutions

ShowEntering text when the formula requires a number or a logical value, such as TRUE or FALSE

Microsoft Excel cannot translate the text into the correct data type. Make sure 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. 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!.

ShowEntering or editing an array formula, and then pressing ENTER

ShowEntering a cell reference, a formula, or a function as an array constant

ShowSupplying a range to an operator or a function that requires a single value, not a range

  • Change the range to a single value.
  • Change the range to include either the same row or the same column that contains the formula.

ShowUsing a matrix that is not valid in one of the matrix worksheet functions

ShowRunning a macro that enters a function that returns #VALUE!

Make sure the function is not using an incorrect argument.

Applies to:
Excel 2003