Validation....divisible by 8 only

[CLR]

Hi All..........

I wish to have Validation in a cell that will only allow numbers that are
evenly divisible by 8. I've done this with a "long" list, but it seems
there should be an easier way..........help please?

Vaya con Dios,
Chuck, CABGx3

 

[Frank Kabel]

Hi
enter the formula (for cell A1)
=MOD(A1,8)=0
in the data validation dialog

 

[Chip Pearson]

Chuck,

Use a Custom type validation, and use =MOD(A1,8)=0 as the
formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Andy B]

Hi

Try this as your Data Validation formula
=MOD(A1,8)=0

 

[mzehr]

Hi Chuck,
Try using a custom formula in the Data Validation:
=MOD(A18,8)=0

HTH

 

[CLR]

Frank, Chip, Andy, Mzehr...........

Thank you kind Sirs.........it works beautifully

Vaya con Dios,
Chuck, CABGx3