Searching if a cell contains a specific piece of text in an IF/OR formula

Hi,

The subject might be a bit confusing so I will try explain what I'm trying to do. I have an IF formula that looks a cells and if it contains 0 is shows "" (blank)and if its got anything else in it does the rest. What I now am trying to get it to do is, if it displays a 0 or a cell contains the word "Doctor" it displays "" (blank)


Example below:

Please Login or Register  to view this content.

The bit I've underlined is what I thought would be the next logical OR statement, but it doesn't work.

Any support much appreciated

John

The problem is likely that Search returns an Error #Value! if the word Doctor is NOT in the cell T31.

Try
=IF(OR('Data Extract'!T31=0,ISNUMBER(SEARCH("Doctor",'Data Extract'!T31,"0"))),"",(" - "&'Data Extract'!T31))

Thanks for the responses. I'm going to use the countifs but is there a way to do it and have the formula look for either "doctor" or "occupational"

I tired this but is doesn't work:

Please Login or Register  to view this content.

Ok I figured this out using 2 count ifs. Maybe it would be easier for me to tell the formula to look at things that are NOT a certain text. it this example really I only want the word "Spare" to be shown and if its "Doctor" or "Occupational" or anything else to not show it.