You could reverse your argument to

=IF(A1="","","+")

It will depend on whether you expect there to be anything else in the cell.
It won't work if there is a number.

There will be a way - I just ain't got it yet

--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Jim D." wrote:

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