try this formula

=IF(ISERROR(SEARCH("COMPLICATION*",A2)*0),0,1)

HTH
--

Thank You

cheers,

========================
please click the Yes button if this help
========================






"JRD" wrote:

I want to use the IF command as follows:

=IF(A1="*complication*", 1,0)

so that if A1 contains "No complication" it would return the answer 1

However it is not working

Does anyone know why?

Thanks

JD