G
gocats
How can set data validation for a cell to accept data between 100 000 and 104
999 or between 40 000 and 99 999?
999 or between 40 000 and 99 999?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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.
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.
G
gocats
Thanks, I should have wiitten 40 000 and 49 999 and 100 000 and 104 999?
G
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<=104999))
Change A1 to the respective cell.
Regards
Govind.
Data->Validation and choose custom and enter this formula.
=OR(AND(A1>=40000,A1<=49999),AND(A1>=100000,A1<=104999))
Change A1 to the respective cell.
Regards
Govind.
G
gocats
Thanks
Works a treat!
Works a treat!
Govind said: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<=104999))
Change A1 to the respective cell.
Regards
Govind.