TM

my apology, your formula provided is working fine. I didn't check the cell's
reference.


--

Thank You

cheers,

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






"Teethless mama" wrote:

=COUNTIF(A1,"*complication*")


"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