If a Cell Does Not Contain "text" Return a Value

**Ocean Zhang** · 07-01-2011, 05:38 PM

How do I write a formula for if cell a1 does not contain "abc" then return the value "Happy 4th of July" otherwise ""?

eg: "dkdkdkdk" should give me the value Happy 4th of July.
"I like to sing my abcs" should return a blank cell.

Thanks!

**Haseeb Avarakkan** · 07-01-2011, 05:48 PM

Hello,

Assume the text is in A1, in B1 enter,

=IF(ISERROR(SEARCH("abc",A1)),"Happy 4th of July","")

Or,

=IF(COUNTIF(A1,"*abc*"),"","Happy 4th of July")

**Ocean Zhang** · 07-01-2011, 06:03 PM

that worked great. thanks!

**Benfella** · 06-28-2019, 07:13 AM

hi

please help me

=COUNTIF(J6:J24,"Disqualified")

countif that range has the text disqualified. if not make 0 in formula

**FlameRetired** · 06-28-2019, 12:43 PM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Please start a new thread - See Forum rule #4

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread