View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default 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