Find Formula Problem

T

thigley986

I have a user that is trying to find whether a cell contains a certai
string (example, 2110) and then evaluate whether it does or not on
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. I
returns a #VALUE error, which is unable to be evaluated as true o
false.

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

CLR

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
 
Top