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