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