IF command

  • Thread starter Thread starter JRD
  • Start date Start date
J

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
 
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
========================
 
try this formula

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

HTH
--

Thank You

cheers,

========================
please click the Yes button if this help
========================
 
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
 
Back
Top