Validation: allow only two numbers.

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.
 
F

Frank Kabel

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