Data validation

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Can data validation be set up to accept a 0( (zero) or any whole number
between 25,000 and 10,000,000? Or does this have to be controlled with VBA?

This needs to work with xll03 and later versions
 
This DV formula should work fine:
=AND(ISNUMBER(A2),A2>=25000,A2<=10000000)
Joy? hit the YES below
 
Thanks you got me going the right direction - however your formula won't
accept 0, because it isn't greater than 25,000

the below equation will work

=OR(D11=0,AND(D11>=25000,D11<=10000000))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation? 2
DATA Validation (Ignore Blanks) 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
A data validation question 1
data validation 1
How to do - B2 is only valid if B1 is zero 1
Copying rows of data into new worksheet but placing data into colu 1
Number format 1

Back
Top