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