| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Data validation
How can set data validation for a cell to accept data between 100 000 and 104
999 or between 40 000 and 99 999? |
|
#2
|
|||
|
|||
|
Hi,
From the range you had specified, why not use a Data-Validation and choose 'Whole number' between '40,000 and 104999'. Choose 'decimal' if you are going to have decimals as well. Govind. gocats wrote: How can set data validation for a cell to accept data between 100 000 and 104 999 or between 40 000 and 99 999? |
|
#3
|
|||
|
|||
|
Thanks, I should have wiitten 40 000 and 49 999 and 100 000 and 104 999?
"Govind" wrote: Hi, From the range you had specified, why not use a Data-Validation and choose 'Whole number' between '40,000 and 104999'. Choose 'decimal' if you are going to have decimals as well. Govind. gocats wrote: How can set data validation for a cell to accept data between 100 000 and 104 999 or between 40 000 and 99 999? |
|
#4
|
|||
|
|||
|
Ok, thats better. Choose the cell where you want the validation, Go to
Data-Validation and choose custom and enter this formula. =OR(AND(A1=40000,A1<=49999),AND(A1=100000,A1<=10 4999)) Change A1 to the respective cell. Regards Govind. gocats wrote: Thanks, I should have wiitten 40 000 and 49 999 and 100 000 and 104 999? "Govind" wrote: Hi, From the range you had specified, why not use a Data-Validation and choose 'Whole number' between '40,000 and 104999'. Choose 'decimal' if you are going to have decimals as well. Govind. gocats wrote: How can set data validation for a cell to accept data between 100 000 and 104 999 or between 40 000 and 99 999? |
|
#5
|
|||
|
|||
|
Thanks
Works a treat! "Govind" wrote: Ok, thats better. Choose the cell where you want the validation, Go to Data-Validation and choose custom and enter this formula. =OR(AND(A1=40000,A1<=49999),AND(A1=100000,A1<=10 4999)) Change A1 to the respective cell. Regards Govind. gocats wrote: Thanks, I should have wiitten 40 000 and 49 999 and 100 000 and 104 999? "Govind" wrote: Hi, From the range you had specified, why not use a Data-Validation and choose 'Whole number' between '40,000 and 104999'. Choose 'decimal' if you are going to have decimals as well. Govind. gocats wrote: How can set data validation for a cell to accept data between 100 000 and 104 999 or between 40 000 and 99 999? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation screen size | Excel Discussion (Misc queries) | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions | |||
Linear Mode
