A1 contains a formula that may or may not copy text from another
worksheet.

When you say "may not" does that mean the cell is blank?

Maybe this:

=IF(A1<"",3,"")

< means: is not equal to

Biff

"Sally in Toronto" wrote in
message ...
Simple problem I'm sure...

if(A1= "*",3,"")

A1 contains a formula that may or may not copy text from another
worksheet.

I realize that the wildcard doesn't work in this context but anything else
I
have tried comes back "true".

Thanks