If text then number

[Guest]

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

 

[Guest]

Maybe: =IF(ISTEXT(A1),3,"")

 

[T. Valko]

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