Maybe: =IF(ISTEXT(A1),3,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sally in Toronto" wrote:
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