cell that only a certain number may be entered

[Guest]

I need a cell to allow only a certain number to be entered such as a 2 or a 0.

 

[Guest]

Use Data Validation.

 

[Guest]

I tried that but it still accepts a different number such as 1

 

[Gord Dibben]

How about DV and Custom =A1=2

Only the number 2 is valid entry for A1.


Gord Dibben MS Excel MVP

 

[Guest]

How would I then tell it that either 0 or 2 are valid?

 

[Gord Dibben]

=OR(A1=0,(A1=2))


Gord

How would I then tell it that either 0 or 2 are valid?

Gord Dibben MS Excel MVP

 

[Guest]

that will work for the 2 but how do I make it accept both the 2 and the 0

 

[Gord Dibben]

I already posted this earlier in response to your post but here it is again.

=OR(A1=0,(A1=2))


Gord