raccoon588
Board Regular
- Joined
- Aug 5, 2016
- Messages
- 118
Hi, I am trying to use data validation. Is it possible to force a user to enter a number between 30 and 60 or put an NA in the cell?
-
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.
Validating text and numbers in one cell
- Thread starter raccoon588
- Start date
-
- Tags
- data vaidation
lrobbo314
Well-known Member
- Joined
- Jul 14, 2008
- Messages
- 3,969
- Office Version
- 365
- Platform
- Windows
Under Data Validation, use the Custom dropdown option. Then in the formula, type the following. I put my data validation in cell J5. Change that to suite your needs.
Code:
=OR(AND(J5>=30,J5<=60),J5="NA")
Upvote
0
