check if an entry is a multiple of another cell

[JMM]

I am creating an order form in which I have cells that are used to enter a
certain quantity of pencils. The pencils must be ordered in multiples of 12.
How can I use Data Validation to check if the ordered quantity is always a
multiple of 12?

Thanks,
JM

 

[Mike H]

Hi,

Select those cells (say a1 - a100) then use data validation formula

=MOD(A1,12)=0

Mike

 

[JE McGimpsey]

You've gotten an accurate answer, but for the convenience of your users,
why don't you just let them order by the dozen (i.e, 1,2..., instead of
12,24...)
?

 

[Jerome]

That was exactly the formula I was looking for. Thank you so much!

 

[Jerome]

That's because of how our system was set up. I agree with you that it would
be easier to order units instead of pieces.