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

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! :)


--
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

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