Return blank cell if 'find' statement not true

I wish to search text in A1 for the word "div". If it is present I want
cell A6 to equal A4. If absent, I want cell A6 to be blank.

When '=IF(FIND("div",A1),A4,"")' is placed in cell A6 it gives '#Value'
instead of blank if A1 does not contain"div".

This seems trivial, but how do I remedy the situation?

Thanks

Hi!

Try one of these:

=IF(ISNUMBER(FIND("div",A1)),A4,"")

=IF(ISERROR(FIND("div",A1)),"",A4)

Note: FIND is case sensitive so if the cell does not contain the EXACT
(sub)string: div, the formula will return "".

Replace FIND with SEARCH if you do not want the formula to be case sensitve.

Biff

"Kanga 85" <[email protected]> wrote in message
news:[email protected]...
>I wish to search text in A1 for the word "div". If it is present I want
> cell A6 to equal A4. If absent, I want cell A6 to be blank.
>
> When '=IF(FIND("div",A1),A4,"")' is placed in cell A6 it gives '#Value'
> instead of blank if A1 does not contain"div".
>
> This seems trivial, but how do I remedy the situation?
>
> Thanks

Thanks Biff

"Biff" wrote:

> Hi!
>
> Try one of these:
>
> =IF(ISNUMBER(FIND("div",A1)),A4,"")
>
> =IF(ISERROR(FIND("div",A1)),"",A4)
>
> Note: FIND is case sensitive so if the cell does not contain the EXACT
> (sub)string: div, the formula will return "".
>
> Replace FIND with SEARCH if you do not want the formula to be case sensitve.
>
> Biff
>
> "Kanga 85" <[email protected]> wrote in message
> news:[email protected]...
> >I wish to search text in A1 for the word "div". If it is present I want
> > cell A6 to equal A4. If absent, I want cell A6 to be blank.
> >
> > When '=IF(FIND("div",A1),A4,"")' is placed in cell A6 it gives '#Value'
> > instead of blank if A1 does not contain"div".
> >
> > This seems trivial, but how do I remedy the situation?
> >
> > Thanks
>
>
>

You're welcome!

Biff

"Kanga 85" <[email protected]> wrote in message
news:[email protected]...
> Thanks Biff
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try one of these:
>>
>> =IF(ISNUMBER(FIND("div",A1)),A4,"")
>>
>> =IF(ISERROR(FIND("div",A1)),"",A4)
>>
>> Note: FIND is case sensitive so if the cell does not contain the EXACT
>> (sub)string: div, the formula will return "".
>>
>> Replace FIND with SEARCH if you do not want the formula to be case
>> sensitve.
>>
>> Biff
>>
>> "Kanga 85" <[email protected]> wrote in message
>> news:[email protected]...
>> >I wish to search text in A1 for the word "div". If it is present I
>> >want
>> > cell A6 to equal A4. If absent, I want cell A6 to be blank.
>> >
>> > When '=IF(FIND("div",A1),A4,"")' is placed in cell A6 it gives
>> > '#Value'
>> > instead of blank if A1 does not contain"div".
>> >
>> > This seems trivial, but how do I remedy the situation?
>> >
>> > Thanks
>>
>>
>>

"Kanga 85" wrote:

> I wish to search text in A1 for the word "div". If it is present I want
> cell A6 to equal A4. If absent, I want cell A6 to be blank.
>
> When '=IF(FIND("div",A1),A4,"")' is placed in cell A6 it gives '#Value'
> instead of blank if A1 does not contain"div".
>
> This seems trivial, but how do I remedy the situation?
>
> Thanks