Related:
- Combine if statement and data validation
- Excel data validation formula if statement - Best answers
- Using multiple if functions with data validation - Forum - Excel
- Using a data validation AND an IF formula in the same cell ✓ - Forum - Excel
- Combine IF statement with validation list - Forum - Office Software
- Excel IF statement with Data Validation - Forum - Excel
- Excel data validation formula if statement - Forum - Excel
2 replies
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
May be like this
=AND(IF(ISNUMBER(E2),AND(E2>0,E2<=40,MOD(E2,1)=0),OR(E2="A",E2="Zero")) , IF(OR(D2="Repeater(s)",D2="Improvement"),FALSE,TRUE))
=AND(IF(ISNUMBER(E2),AND(E2>0,E2<=40,MOD(E2,1)=0),OR(E2="A",E2="Zero")) , IF(OR(D2="Repeater(s)",D2="Improvement"),FALSE,TRUE))
smuneeb
- Posts
- 77
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- March 8, 2017
Hi
Just to bring to your kind knowledge with your formula
one thing I have noted that if D2 cell is empty then this formula doesn't work
in any conditions what ever enter value it accepted
but I have uncheck the Ignore Blank in Validation Criteria then it worked.
Thanks
Just to bring to your kind knowledge with your formula
one thing I have noted that if D2 cell is empty then this formula doesn't work
in any conditions what ever enter value it accepted
but I have uncheck the Ignore Blank in Validation Criteria then it worked.
Thanks
- Posts
-
77
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- March 8, 2017
1Thanks Great you have done awesome job
Excellent
Thanks