#VALUE

Question

What does #VALUE  mean?

Answer 1

The #value error occurs when the wrong type of argument or operand is used.

Click the cell that displays the error, click the button that appears , and then click Trace Error if it appears.

Possible causes:

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

Entering or editing an array formula, and then pressing ENTER

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

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

Answer 2

skat100 wrote:

What does #VALUE  mean?

It can mean many things, depending on context.  The Excel 2003 Help page "Correct a #VALUE Error" hints at some root causes:

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

   Note:  But text that looks like a number can be used in arithmetic expressions.

* Entering or editing an array formula, and then pressing ENTER

   ... Instead of ctrl+shift+Enter

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

   Also:  Using ranges of inconsistent sizes; e.g. SUMPRODUCT.

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

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

   Also:  A formula that references a VBA user-defined function that contains an error.

* Also:  A reference to a cell that results in a #VALUE error.

If you are asking about a particular #VALUE error, it would behoove you to post the formula that returns #VALUE, ideally along with formulas, values and type (text v. number) in any referenced cells.

Answer 3

Hi,

It generally means you've tried to carry out a mathmatical operation on text. For example

A1= a text value

the formula =A1*1 returns a value error.

It isn't always as obvious as that because sometimes cell contents that look like numbers can actually be text and give this error.

---

If this post answers your question, please mark it as the Answer.

Mike H