IF command

[JRD]

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

 

[Teethless mama]

=COUNTIF(A1,"*complication*")

 

[xlm]

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
========================

 

[xlm]

try this formula

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

HTH
--

Thank You

cheers,

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

 

[xlm]

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