Cell Value

[Garyw]

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)

 

[Peo Sjoblom]

You need VBA to tell if a cell holds a formula

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