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
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
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:
- If then data validation
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Mint mobile data not working ✓ - Network Forum
- How to reset safe folder password without losing data ✓ - Android Forum
- Gta 5 data download for pc - Download - Action and adventure
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 6, 2015 at 10:02 AM
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))
Nov 6, 2015 at 11:26 AM
Thanks Great you have done awesome job
Excellent
Thanks