- Joined
- Nov 4, 2011
- Messages
- 1
- Reaction score
- 0
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:
=IF(AND(E4<1/1/1900,G4<1/1/1900,H4<1/1/1900,I4<1/1/1900,J4<1/1/1900,K4<1/1/1900,L4<1/1/1900,M4<1/1/1900,N4<1/1/1900,O4<1/1/1900,P4<1/1/1900,Q4<1/1/1900,R4<1/1/1900,S4<1/1/1900,T4<1/1/1900),"YES","NO")
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.
Thanks!!!
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:
=IF(AND(E4<1/1/1900,G4<1/1/1900,H4<1/1/1900,I4<1/1/1900,J4<1/1/1900,K4<1/1/1900,L4<1/1/1900,M4<1/1/1900,N4<1/1/1900,O4<1/1/1900,P4<1/1/1900,Q4<1/1/1900,R4<1/1/1900,S4<1/1/1900,T4<1/1/1900),"YES","NO")
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.
Thanks!!!