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