Simple question?
 

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

Simple question?
 

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

Regards,
Paul
..

--

"Jo" wrote in message
ups.com...
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

Simple question?
 

On Aug 21, 12:16 pm, "PCLIVE" wrote:
Chances are that either John or K59 is not a number. Also, verify that your
named cell is referenced correctly

Regards,
Paul
.

--

"Jo" wrote in message

ups.com...



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- Hide quoted text -

- Show quoted text -

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

Simple question?
 

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" wrote in message
oups.com...
On Aug 21, 12:16 pm, "PCLIVE" wrote:
Chances are that either John or K59 is not a number. Also, verify that
your
named cell is referenced correctly

Regards,
Paul
.

--

"Jo" wrote in message

ups.com...



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- Hide quoted text -

- Show quoted text -

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

Simple question?
 

On Aug 21, 12:43 pm, "PCLIVE" wrote:
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" wrote in message

oups.com...



On Aug 21, 12:16 pm, "PCLIVE" wrote:
Chances are that either John or K59 is not a number. Also, verify that
your
named cell is referenced correctly

Regards,
Paul
.

--

"Jo" wrote in message

roups.com...

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- Hide quoted text -

- Show quoted text -

It is referenced as a Number, but the error still there!?- Hide quoted text -

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