Do you want to input data in Microsoft excel but give a limit value to the cell? Can we do that in Excel? Yup..please find the tips below:
For example we want to give limit data between 10 to 100
1. Select the cell that we want to give the data ex : D2:D5
2. Select data validation (in tab Data -> Data Validation)
3. Input data in Tab setting after select Data Validation :
-Allow : Decimal
-Data : Beetwen
-Minimum : 10
-Maximum : 100
4. press ok
Test input data outside the range Ex : 101 then you will have an Error Message.
You can modify the Error Message by setting the error Message in Tab Error Alert.
For detail step for this tips you can download the PDF file in this location.
Related Topics:
How to configure Word, Excel 2007 options to save file into 97-2003 format?
Easy tips to create graphic in Excel
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
Easy tips to delete blank rows in Excel
Microsoft Excel 2007: How to take limit value to the cell
how can I set limits from 1 to 100 in "B1",If "B1" is a subproduct of "A1" ?
ReplyDelete"A1" has a slider from 0 to 100 ... works ok but, when I try to set limits in "B1"...doesnt work and "B1" goes beyond max limit (100)
Ex: (B1 = A1+2)... i want B1 to be stopped when reachs 100 not wanting "102"
Hi giancarlo,
ReplyDeleteI think there is no problem with that, see my example below (I upload the image excel)
http://i381.photobucket.com/albums/oo254/gokhiel1/limitvalueinexcel.jpg
there is an error message when you try to input data more then 100.