Hi, I have attached a spreadsheet with data, showing the cells that I need to reference to achieve a "Yes" or "NO" result
Thankyou
Hi, I have attached a spreadsheet with data, showing the cells that I need to reference to achieve a "Yes" or "NO" result
Thankyou
Last edited by lohnro; 02-01-2015 at 02:53 AM.
Based on your sample, this seems to work...
=IF(AND(A1=1,C1=1,L1=4,OR(M1=1,M1=2),OR(N1=S1,N1=T1),OR(O1=1,O1=2,O1=4),OR(P1=0,P1=1),OR(Q1=1,Q1=2)),"Yes","No")
It could probably be simplified if I has some idea of what other values might be in those columns.
For instance, if M will always be positive and always >1, then the OR(M1=1,M1=2) could be reduced to M1<3, etc
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you, that is perfect appreciate you completing this for me,and the detail
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks