Returning a YES or NO if there is a value on a range of cells

Nov 4, 2011
Reaction score
Hi everyone, I am trying to figure out how to get a YES or NO result. I am working with a spreadsheet that needs to tell me if a candidate has the required spec.
If the candidate on row A1 has the requirement on E1, AND either one from G1 to K1, AND L1, and either one from M1 to T1, the result should be YES. I have 1 candidate per row and several training on the columns, on the cells I enter the date such training was done
I've tried to work with the IF/AND formula:
but it gives me a YES if no date are entered.
I know it is confusing...please help, I will send the spread sheet itself if needed.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question