Cell Value
 

In a formula how do I represent a cell with any value other than a formula.
Example: =If($A$1=(Anything other than a formula) ,6,2)
--
Garyw

Cell Value
 

You need VBA to tell if a cell holds a formula

http://www.mvps.org/dmcritchie/excel...htm#hasformula




--
Regards,

Peo Sjoblom



"Garyw" wrote in message
...
In a formula how do I represent a cell with any value other than a
formula.
Example: =If($A$1=(Anything other than a formula) ,6,2)
--
Garyw