Constant Value in formula.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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'!
 
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
 
You must log in or register to reply here.

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

formulas 5
Mapping integers to strings 5
Trying to avoid nested IFs 8
Top 4 scores in excel 4
Formula To Bring The Best Name 2 2
Is this possible with Excel 4
If results for multiple cells 1
Automatically copy formula in column when adding new row.... 2

Back
Top