View Single Post
  #1   Report Post  
Nomad
 
Posts: n/a
Default Constant Value in formula.

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'!
--
Thanx,
Guy