OK, thanks everyone for your responses. So since using ISLOGICAL will not
provide the desired solution, let me provide more detail to what I am
attempting to do.

Cells in column A will contain text or contain nothing. In column B's
cells, I want to have a formula that checks the adjacent column A cell to see
if its text contains any of five specified six-character strings that may be
present anywhere in the text (there will not be more than one of the values
in each cell) and then display the six-character text that may be found or
indicate that none of the searched-for strings are present. I tried some
ISERROR combinations but can't find a suitable solution.

--
EarlyBirdie


"Roger Govier" wrote:

Hi

Find returns the starting position within the cell for the text being found,
1 in cell A1 and 11 in cell A3
If it is not found, then it will return a #VALUE error.

ISLOGICAL can only deal with values which return True or False

I don't understand why using ISERROR makes the formula too complex, compared
with ISLOGICAL
You could use ISNUMBER, but you would need to reverse your outcomes.
=IF(ISNUMBER(FIND("Claim",A1,1)),"Claim","No Claim")
--
Regards
Roger Govier

"EarlyBirdie" wrote in message
...
Cell A1 contains the value "Insurance Claim" and Cell A2 contains the
value
"Insurance Loss" and Cell A3 contains the value "Claim for Insurance".
The
adjacent cells in column B contain the formula
=IF(ISERROR(FIND("Claim",Ax,1)),"No Claim","Claim"), where "x" is the row
number and these formulas do return the expected results: "Claim", "No
Claim"
and "Claim" in the respective cells. However, when I change the formulas
to
read =IF(ISLOGICAL(FIND("Claim",Ax,1)),"Claim","No Claim"), they display
"No
Claim" for all three cells. I expected to see the same results as
generated
by the ISERROR formula. Any idea for correcting the ISLOGICAL formula or
any
explanation why these are the results? I have a more complex set of data
where using the ISERROR function makes the formula too complex to give the
desired results.


--
EarlyBirdie