Thread: check if an entry is a multiple of another cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default check if an entry is a multiple of another cell
Hi,

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

=MOD(A1,12)=0

Mike

"JMM" wrote:

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