Data Validation formulas
 

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.
--
Lele

Data Validation formulas
 

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

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

hth

"Lele" wrote:

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.
--
Lele

Data Validation formulas
 

Lele,

=MOD(B1,4)=0

This will return TRUE if the value in B1 is a multiple of 4.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Lele" wrote in message
...
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.
--
Lele

Data Validation formulas
 

Thanks, works great
--
Lele


"Earl Kiosterud" wrote:

Lele,

=MOD(B1,4)=0

This will return TRUE if the value in B1 is a multiple of 4.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Lele" wrote in message
...
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.
--
Lele

Data Validation formulas
 

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


"Toppers" wrote:

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

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

hth

"Lele" wrote:

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.
--
Lele