Correct a #VALUE! error

This error occurs when the wrong type of argument or operand is used.

1. Optionally, click the cell that displays the error, click the button that appears , and then click Show Calculation Steps if it appears.
2. Review the following possible causes and solutions.

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

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

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

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

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

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

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

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

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

   Make sure that the function is not using an incorrect argument.