Validation....divisible by 8 only

  • Thread starter Thread starter CLR
  • Start date Start date
C

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
 
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
 
Frank, Chip, Andy, Mzehr...........

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

Vaya con Dios,
Chuck, CABGx3
 
Back
Top