If text then number

  • Thread starter Sally in Toronto
  • Start date
S

Sally in Toronto

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
 
T

T. Valko

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

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

Maybe this:

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

<> means: is not equal to

Biff
 
Top