check if an entry is a multiple of another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JMM - 02 May 2008 22:52 GMT

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

Reply to this Message

Mike H - 02 May 2008 23:08 GMT

Hi,

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

=MOD(A1,12)=0

Mike

> 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.
[quoted text clipped - 3 lines]
> Thanks,
> JM

Reply to this Message

Jerome - 03 May 2008 00:11 GMT

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

> Hi,
>
[quoted text clipped - 14 lines]
>> Thanks,
>> JM

Reply to this Message

JE McGimpsey - 02 May 2008 23:16 GMT

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...)
?

> 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?

Reply to this Message

Jerome - 03 May 2008 00:13 GMT

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.

> 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
[quoted text clipped - 8 lines]
>> a
>> multiple of 12?

Reply to this Message