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