check if an entry is a multiple of another cell

  • Thread starter Thread starter JMM
  • Start date Start date
J

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
 
Hi,

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

=MOD(A1,12)=0

Mike
 
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...)
?
 
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.
 
Back
Top