Data Validation formulas

[Guest]

I am working on creating an order form for our customers. Items must be
ordered in multiples of the "box discount quantity". So far I have set data
validation for this cell to require the value entered to be equal to or
greater than the value shown in the box discount quantity cell. Is there a
way to validate that this value is a multiple of the box discount quantity?
So if the box discount quantity was 4, the user could only enter 4, 8, 12,
etc.
Thanks for any suggestions.

 

[Guest]

If discount quantity is in A1 and Data validation is for B1:

For B1, Data Validation==>Custom==> =MOD(B1,A1)=0

hth

 

[Earl Kiosterud]

Lele,

=MOD(B1,4)=0

This will return TRUE if the value in B1 is a multiple of 4.

 

[Guest]

Thanks, works great
--
Lele

Lele,

=MOD(B1,4)=0

This will return TRUE if the value in B1 is a multiple of 4.

 

[Guest]

Wow, that was easy. I have used the MOD function once before in the past,
just could not figure it out this time. Thanks so much