J
jbailey
I need a cell to allow only a certain number to be entered such as a 2 or a 0.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
Use Data Validation.
J
jbailey
I tried that but it still accepts a different number such as 1
G
Gord Dibben
How about DV and Custom =A1=2
Only the number 2 is valid entry for A1.
Gord Dibben MS Excel MVP
Only the number 2 is valid entry for A1.
Gord Dibben MS Excel MVP
J
jbailey
How would I then tell it that either 0 or 2 are valid?
G
Gord Dibben
=OR(A1=0,(A1=2))
Gord
Gord Dibben MS Excel MVP
Gord
How would I then tell it that either 0 or 2 are valid?
Gord Dibben MS Excel MVP
J
jbailey
that will work for the 2 but how do I make it accept both the 2 and the 0
G
Gord Dibben
I already posted this earlier in response to your post but here it is again.
=OR(A1=0,(A1=2))
Gord
=OR(A1=0,(A1=2))
Gord