Ask a question Report

Multiple If in Data Validation [Solved/Closed]

smuneeb 77 Posts Saturday September 5, 2015Registration date March 8, 2017 Last seen - Nov 6, 2015 at 05:05 AM - Latest reply: smuneeb 77 Posts Saturday September 5, 2015Registration date March 8, 2017 Last seen

- 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

3 replies

Report Respond to rizvisa1

rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Nov 6, 2015 at 10:02 AM

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

smuneeb 77 Posts Saturday September 5, 2015Registration date March 8, 2017 Last seen - Nov 6, 2015 at 11:26 AM

Hi

Thanks Great you have done awesome job
Excellent
Thanks

Report Respond to smuneeb

smuneeb 77 Posts Saturday September 5, 2015Registration date March 8, 2017 Last seen - Nov 6, 2015 at 01:21 PM

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

Multiple If in Data Validation [Solved/Closed]

Your reply