Data Validation Question

**johnnyd7** · 02-13-2015, 03:13 AM

I am doing an assignment and I am being asked to use data validation to restrict a user from entering a value that is outside the range ">0" and "<=500".
I have no idea how to accomplish this. I can't use the between option because then the user could type in 0. What other options are there?

**tchock** · 02-13-2015, 03:24 AM

In data validation, custom, write this formula:
=AND(A1>0,A1<=500)

**alexgempesaw** · 02-13-2015, 03:30 AM

Hi,

On the toolbar select Data tab then click Data Validation. A window will appear, in the settings tab Validation criteria\Allow select Whole number; Data select between; Minimum: 0; Maximum: 500.

Happy to be of assistance!

Regards,

Alex

**johnnyd7** · 02-13-2015, 03:38 AM

Originally Posted by tchock

In data validation, custom, write this formula:
=AND(A1>0,A1<=500)

I entered the formula, however, now I whenever I try typing something, the cell remains blank.
EDIT: Ignore that haha. IT WORKED!! THANK YOU SO MUCH!!