Data Validation Question

[cionnaith]

Hi Folks.

I am trying to create cells that accept only the values of 0, 2 and 4. How do I do that using data validation. In addition, I have set up another cell to count those entries and a 0 entry needs to be counted as a value.

Any help is much appreciated.

Thanks!

 

[JimM]

Data > Validation > Settings tab - drop down box to list and put in 0,2,4 in the source box

To count the results


=COUNT(A1:A999)

 

[JamesW]

Hi,

Jim's solution is the way I would go, however you could also do this if you don't want to have a listbox:

=NOT(AND(A1<>0,A1<>2,A1<>4))

 

[JackDanIce]

James,

Out of curiosity, why not use:

=OR(G2=0,G2=2,G2=4)

Jack

(In Data->Data Validation->Settings->Allow: Custom under formula)

 

[cionnaith]

Thank you everyone!!

 

[JamesW]

James,

Out of curiosity, why not use:

=OR(G2=0,G2=2,G2=4)

Jack

(In Data->Data Validation->Settings->Allow: Custom under formula)

Because I always seem to come up with a difficult way to solve and easy problem It's a bad habit.

 

[JackDanIce]

Got it!