Would I be right in saying that you could change IF(condition,FALSE,TRUE) to
NOT(condition) ?

Hence
=IF(OR(NOT(ISERR(SEARCH("testing",A3))),NOT(ISERR( SEARCH("cold",A3))),NOT(ISERR(SEARCH("working",A3) ))),"Yes","No")
and then presumably
=IF(AND(ISERR(SEARCH("testing",A3)),ISERR(SEARCH(" cold",A3)),ISERR(SEARCH("working",A3))),"No","Yes" )
?
--
David Biddulph

"JLatham" wrote in message
...
Oops, turns out to work better if you use SEARCH instead:

=IF(OR(IF(ISERR(SEARCH("testing",A3)),FALSE,TRUE), IF(ISERR(SEARCH("cold",A3)),FALSE,TRUE),IF(ISERR(S EARCH("working",A3)),FALSE,TRUE)),"Yes","No")


"vinstream" wrote:

Hi,

I have the following sample data in column A.

germany (testing)
Germany (cold)
Germany
Austria (Testing)
Austria (cold)
Austria (working)
Austria (other)
China
China (alternate)


In column B, I want it to show that if the cell to the left has any of
the words 'testing' or 'cold' or 'working' it should show "yes" in
Column B else show "no".

Is this possible?



Regards,

Vinstream


.