Validation: allow only two numbers.

  • Thread starter Thread starter JEM
  • Start date Start date
J

JEM

Cell starts off blank - I want users to enter only the numbers '0' or '20',
not the numbers between 1-19. Can this be done with Validation > Custom >
Formula?

Thanks.
 
Hi
enter the following formula in the validation dialog
(category 'custom') if you want to apply this rule for
cell A1:
=(A1=0)+(A1=20)
 
You could also us
Data>Validation>Lis

Enter 0,20 in the "Source" bo

HT
Geoff
 
You must log in or register to reply here.

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

Testing a cell value for a specific weekday. 3
Data validation for specific text, for example "blue"? 1
custom data validation on cells with data validation values 2
Data Validation - Complex Q 2
Need some help with a COUNTIF function 4
Locking Cell through Validation 3
Data Validation w/o Cell Content Deletion 1
Data Validation, Identify Duplicates and Limit imput 7

Back
Top