Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Multiple If in Data Validation

[Solved/Closed]
Report
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
 -
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
 -
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
Related:

2 replies

Answer 1 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
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
Status
Member
Last seen
March 8, 2017
 1
Hi

Thanks Great you have done awesome job
Excellent
Thanks
Answer 2 / 2
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
 1
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!