=OR(COUNTIF(E5:N5,"Yes"),COUNTIF(E5:N5,"#N/A"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"TD" wrote in message
...
Oh help!

What I want to do is find which jobs haven't been completed.

E to N holds different job categories and the contents of these cells
could
be Yes Not complete or N/A or blank.

I tried this formula and got #value!

=IF(OR(E5:N5="Yes",E5:N5="N/A"),TRUE,FALSE)

I was then going to filter on False to see what work was outstanding for
each person in column D

Please help it is Friday and in since early and brain gone mushy!

Thank you

--
TD