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


Gord

On Thu, 24 Aug 2006 12:31:02 -0700, jbailey
wrote:

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

"Gord Dibben" wrote:

How about DV and Custom =A1=2

Only the number 2 is valid entry for A1.


Gord Dibben MS Excel MVP

On Thu, 24 Aug 2006 10:14:02 -0700, jbailey
wrote:

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

"Gary''s Student" wrote:

Use Data Validation.
--
Gary''s Student


"jbailey" wrote:

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



Gord Dibben MS Excel MVP