in excel how can I get the number to show instead to #value in th.

[excel]

in excel how can I get the number to show instead of #value in the cell where
I used a formula

[Biff]

Hi!

#VALUE! means the formula is returning an error. You're
using an improper data type in the formula.

Post the formula with a detailed explanation of what it is
you're trying to do.

Biff

>-----Original Message-----
>in excel how can I get the number to show instead of
#value in the cell where
>I used a formula
>.
>

[Gord Dibben]

Not much to go on here but a couple of guesses.

If the formula is an array formula it must be entered using CTRL + SHIFT +
ENTER or you will get the error.

If one or more of the values is not really a number, you will get the error.

If any of the referred to cells has a formula with an error you will get the
error.

Perhaps post a sample(not a file) of your data and formula.


Gord Dibben Excel MVP

On Sat, 29 Jan 2005 19:39:03 -0800, "excel" <[email protected]>
wrote:

>in excel how can I get the number to show instead of #value in the cell where
>I used a formula