=if() statement -- test for any text in cell

  • Thread starter Thread starter Jim D.
  • Start date Start date
J

Jim D.

Hi,

I'm trying to convert the following statement . . . =if(A1=______ , "+", "")

to . . . a search for any text, that might happen to be in cell A1.

I don't know what the best option is for filling in the blank after A1=


Thanks So much hor helping me if possible,

Jim
 
If you are looking specifically for text, you can use the istext function,
as in:
=if(istext(a1),"+","")

Regards,
Fred
 
Thanks Guys !!

I had tried to get istext to work, but I'm not that great at combining the
functions, I was mistakingly placing the = before istext . . . =if(=istext

I loved the reverse the argument advice. That actually ended up solving
another issue I didn't even know I had.

Both comments were Great!

Thanks so much,

Jim
 
Back
Top