Menu
Ask a question Report

Multiple If in Data Validation [Solved/Closed]

Posts
77
Registration date
Saturday September 5, 2015
Last seen
March 8, 2017
 - Nov 6, 2015 at 05:05 AM - Latest reply:
Posts
77
Registration date
Saturday September 5, 2015
Last seen
March 8, 2017
 - Nov 6, 2015 at 01:21 PM
Excel Ask a question Report
Hello,

Its being requested please help in the below multiple IF function used in Data Validation

=IF(ISNUMBER(E2),AND(E2>0,E2<=40,MOD(E2,1)=0),OR(E2="A",E2="Zero"))
and
=IF(OR(D2="Repeater(s)",D2="Improvement"),FALSE,TRUE

They both work individually. How they become one Formula for E2 Cell?

Thanks & Regards
See more 

3 replies

Report Respond to rizvisa1
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
 Nov 6, 2015 at 10:02 AM
0
Thank you
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))
Report
Posts
77
Registration date
Saturday September 5, 2015
Last seen
March 8, 2017
 - Nov 6, 2015 at 11:26 AM
Hi

Thanks Great you have done awesome job
Excellent
Thanks
Report Respond to smuneeb
Posts
77
Registration date
Saturday September 5, 2015
Last seen
March 8, 2017
 Nov 6, 2015 at 01:21 PM
0
Thank you
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
Ask a question