Share via

#VALUE

Anonymous
2010-08-01T16:03:49+00:00

What does #VALUE  mean?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-08-02T13:18:55+00:00

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

Was this answer helpful?

2 people found this answer helpful.
0 comments

Answer accepted by question author

Anonymous
2010-08-01T16:47:15+00:00

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.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-08-01T16:18:35+00:00

    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

    Was this answer helpful?

    0 comments