Thread: check if an entry is a multiple of another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMM[_2_] JMM[_2_] is offline
external usenet poster
  
Posts: 1
Default check if an entry is a multiple of another cell
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 With QuoteReply With Quote