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

=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

The formula provided doesn't seem to work,
if in A1 contains "No complication", then the result expected is 1,
but the formula give a 0.
the same goes if "no complicates", the expected result should be 0,
but yours give a 1

what will be the expected result if A1 contain "lesscomplications"

HTH

--

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

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

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