If text then number
 

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

If text then number
 

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

If text then number
 

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