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)
 
Back
Top