Correct a #VALUE! error

Microsoft Office Excel 2003

previous page next page
  • Click the cell that displays the error, click the button that appears Button image, and then click Trace Error if it appears.
  • 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

    Select the cell or range of cells that contains the array formula, press F2 to edit the formula, and then press CTRL+SHIFT+ENTER.

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

    Make sure the array constant is not a cell reference, formula, or function.

    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

    Make sure the dimensions of the matrix are correct for the matrix arguments.

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

    Make sure the function is not using an incorrect argument.

    previous page start next page