ExcelBanter - Data validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data validation (https://www.excelbanter.com/excel-discussion-misc-queries/41736-data-validation.html)

gocats

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?

Govind

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?

gocats

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?

Govind

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?

gocats

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?

All times are GMT +1. The time now is 06:49 AM.