If Or statement help

[TD]

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

 

[Bob Phillips]

=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]

Hi Bob and thanks for responding,

Just tried it out, it works fine for the Falses where cells are either not
complete or blank but for the Trues where there are Yes and Not Complete in
the same row I would like it to return False.

Any way to do this?

Thanks again

 

[Idoia]

Try this.

=NOT(OR(COUNTIF(E12:N12,"Not Completed"),COUNTIF(E12:N12,"")))

 

[Bob Phillips]

Do you mean just one (or more) Yes and one (or more) #N/A, or do you mean
all of E5:N5 is either Yes or #N/A?

--
HTH

Bob

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