Simple question?

[Jo]

Hi,

I have a cel named as, say, "John"

In another cell, I have a formula like this: =K59*John

I get: #VALUE!......................WHY?

What I missing here?

Thanks,
Jo

 

[PCLIVE]

Chances are that either John or K59 is not a number. Also, verify that your
named cell is referenced correctly

Regards,
Paul
..

 

[Jo]

Chances are that either John or K59 is not a number. Also, verify that your
named cell is referenced correctly

Regards,
Paul
.

--











- Show quoted text -

It is referenced as a Number, but the error still there!?

 

[PCLIVE]

You might try testing the two values for being numbers.

=ISNUMBER(John)
=ISNUMBER(K59)

If either one of these return false, then check them again. Make sure the
cell is formatted as either General or Number. Once verified, click on the
cell named John, press F2 and then Enter. Do the same for K59. Then press
F9 to calculation

HTH,
Paul


--

 

[Jo]

You might try testing the two values for being numbers.

=ISNUMBER(John)
=ISNUMBER(K59)

If either one of these return false, then check them again. Make sure the
cell is formatted as either General or Number. Once verified, click on the
cell named John, press F2 and then Enter. Do the same for K59. Then press
F9 to calculation

HTH,
Paul

--







- Show quoted text -

Thanks Paul, I had the value in "John" as $3.00.......I did remove it
and re-put as 3.00 and worked.....