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?