Multiple If in Data Validation
Solved/Closed
smuneeb
smuneeb
- Posts
- 77
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- March 8, 2017
smuneeb
- Posts
- 77
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- March 8, 2017
Related:
- Multiple if statements in excel data validation
- Excel data validation formula if statement - Best answers
- Data validation 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
- Multiple IF statements in Excel ✓ - Forum - Excel
- Combine IF statement with validation list - Forum - Office Software
- Excel IF statement with Data Validation - Forum - Excel
2 replies
rizvisa1
Nov 6, 2015 at 10:02 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Nov 6, 2015 at 10:02 AM
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
Nov 6, 2015 at 01:21 PM
- Posts
- 77
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- March 8, 2017
Nov 6, 2015 at 01:21 PM
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
Nov 6, 2015 at 11:26 AM
Thanks Great you have done awesome job
Excellent
Thanks