Constant Value in formula.

N

Nomad

The below formula when viewed in 'Formula Auditor' refers to '(L4)' as a
'constant'. How do I get it to recognize it as a 'valid reference'. I am
trying to reference it from cell 'M2'.

=IF(ISNUMBER(L4),"Good","Enter Again!")

Please help... I'm 'bumfuzzled'!
 
B

bj

The equation works for me as copied from your listing.
Does it always say "Reenter" no matter what you have in L4?
If it does, insure that it is actually a number and not a number entered as
text.
The saying it is a constant just implies it is an entered value in L4 rather
than an equaition
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing an External Cell 1
Mapping integers to strings 6
Leave final cell blank 2
Using Formulas 3
Adding dates in a IF Statement 2
Automatically copy formula in column when adding new row.... 2
Drop down list control value in vba 2
Would like to input 3 letters into a cell, each having a different numerical value 5

Top