Issues with IF Formula with multiple conditions

Hello everyone,

Basically this is a table to verify if an employee has submitted all the required documents for their position. There are 3 options Y (Yes) N (No) NA (Not applicable) (The NA is for documents that are not pre requisites for a given position)

The IF formula in C5 is supposed to tell me
IF every field is marked as either Y or NA, then “YES” all files have been rec’d and conversely if they weren’t a “NO”.

My problem is: There is a “N” in my fields from H3:X3 it returns FALSE instead of my chosen “NO” for my if_false. I’m not sure why I have played with it a few times but it doesn’t work. Ultimately the false provides me with the same information but since this is dealing with over 9000 rows I’d like to verify the formula works correctly. Any help is appreciated, thanks!

Best regards,

Dawson GForumHELP.jpg

that will work to identify the N. but i need the formula to be able to do both. If all fields are either Y or NA then its YES but If it counts any N its no. or are you thinking to integrate the two of them? my long IF(AND(OR with the countif?

The formula works great but im not sure how to integrate it with the current formula in C5. i want the one cell to be able to give the answer. am i just not seeing it?

side note: my IF(AND(OR formula in cell C5 i tried to shorten it by having each condition apply to H3:W3 as opposed to each column individually but i was getting an error. i could format the sheet and post a condensed version if it helps. (the original is not only big but it contains employees personal info). thanks again

I believe the suggested formula is intended to 'Replace' the existing formula from C5.
Not to be 'integrated' into it.

Yup that worked. Of course I was so busy trying to complicate things I didn't step back and realize the new formula will replace the same criteria from the other. Thanks for pointing out what I refused to see, much appreciated!

Glad to help.