Find Formula Problem

I have a user that is trying to find whether a cell contains a certain string (example, 2110) and then evaluate whether it does or not on a True/False basis. This is the formula he is trying to use:

=IF(FIND("1220",B1),TRUE,FALSE)

The problem arises when the FIND function does not find that value. It returns a #VALUE error, which is unable to be evaluated as true or false.

Is there a way to do what he'd like to?

This formula seems to work:

=IF(ISNUMBER(FIND(2110,B1)), TRUE, FALSE)

--
Kevin Vaughn


"thigley986" wrote:

>
> I have a user that is trying to find whether a cell contains a certain
> string (example, 2110) and then evaluate whether it does or not on a
> True/False basis. This is the formula he is trying to use:
>
> =IF(FIND("1220",B1),TRUE,FALSE)
>
> The problem arises when the FIND function does not find that value. It
> returns a #VALUE error, which is unable to be evaluated as true or
> false.
>
> Is there a way to do what he'd like to?
>
>
> --
> thigley986
> ------------------------------------------------------------------------
> thigley986's Profile: http://www.excelforum.com/member.php...o&userid=31967
> View this thread: http://www.excelforum.com/showthread...hreadid=516927
>
>

Thanks, you're a life saver!

With the search string in A1,
=IF(ISERR(FIND(A1,B1,1)),"String Not Found",IF(FIND(A1,B1,1),"TRUE","FALSE"))

Vaya con Dios,
Chuck, CABGx3


"thigley986" wrote:

>
> I have a user that is trying to find whether a cell contains a certain
> string (example, 2110) and then evaluate whether it does or not on a
> True/False basis. This is the formula he is trying to use:
>
> =IF(FIND("1220",B1),TRUE,FALSE)
>
> The problem arises when the FIND function does not find that value. It
> returns a #VALUE error, which is unable to be evaluated as true or
> false.
>
> Is there a way to do what he'd like to?
>
>
> --
> thigley986
> ------------------------------------------------------------------------
> thigley986's Profile: http://www.excelforum.com/member.php...o&userid=31967
> View this thread: http://www.excelforum.com/showthread...hreadid=516927
>
>

You're welcome!
--
Kevin Vaughn


"thigley986" wrote:

>
> Thanks, you're a life saver!
>
>
> --
> thigley986
> ------------------------------------------------------------------------
> thigley986's Profile: http://www.excelforum.com/member.php...o&userid=31967
> View this thread: http://www.excelforum.com/showthread...hreadid=516927
>
>