Add a UDF

Function IsFormula(rng as Range)
If rng.Coount = 1 Then
IsFormula = rng.HasFormula
End If
End SUb

and use like

=IF(Isformula(B2),....)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mike" wrote in message
oups.com...
Hi everyone,

Say I have in cell B2 a function like this: "=If(c2=5,1,0)" OR this
"=1+34*x" and I want to check from cell F5 to see if what I have in B2
is like this:

if(or(b2 = "=If",b2="=1"),.....)

I don't want to put the whole function just the 1st part of it; if it
has "=If" or "=1"

How can I do so?

Thanks,
Mike