If I setup a spreadsheet for others to use and I want them to enter their own numbers in certain cells... BUT... restrict those numbers to be from, say 0 to 50... what is the formula or how is it done?
In this example I do not want to allow negative numbers or numbers > 50.
Thanks,
Steve
Last edited by oldchippy; 11-05-2008 at 07:09 PM.
Hi,
Take a look at Data Validation, here's a link
http://www.contextures.com/xlDataVal01.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
PERFECT!!! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks