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:

=IF(OR('Data Extract'!T31=0,SEARCH("Doctor",'Data Extract'!T31,"0")),"",(" - "&'Data Extract'!T31))
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