Multiple If in Data Validation

Solved/Closed

smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 6, 2015 at 05:05 AM
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 6, 2015 at 01:21 PM

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

Multiple if statements in excel data validation
Using multiple if functions with data validation - Excel Forum
How many if statements can you nest - Guide
Excel data validation list from table multiple columns - Guide
Transfer data from one excel worksheet to another automatically - Guide
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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))

smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 1
Nov 6, 2015 at 11:26 AM

Hi

Thanks Great you have done awesome job
Excellent
Thanks

Similar discussions

using a data validation AND an IF formula in the same cell

using multiple if functions with data validation

Excel IF statement with Data Validation

Removing "FALSE" from an IF statement with a VLOOKUP

removing false in excel

Removing False Value

Similar discussions

Subscribe To Our Newsletter!