-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Data Validation (Multiple Criteria)
tyija1995
Well-known Member
- Joined
- Feb 26, 2019
- Messages
- 781
- Office Version
- 365
- Platform
- Windows
Hey,
Use a custom criteria in the cell that you want to data validate (Lets use E1 for this example):
Put the formula as:
=OR(E1="NA",AND(E1>0,E1<100))
Note that this will not allow 0 or 100, but will allow any number inbetween. this can be easily changed by amending the equality symbol to >= & <= respectively.
Use a custom criteria in the cell that you want to data validate (Lets use E1 for this example):
Put the formula as:
=OR(E1="NA",AND(E1>0,E1<100))
Note that this will not allow 0 or 100, but will allow any number inbetween. this can be easily changed by amending the equality symbol to >= & <= respectively.
Upvote
0
