Thread: Data Validation...A Multiple of a number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
colofnature[_58_] colofnature[_58_] is offline
external usenet poster
  
Posts: 1
Default Data Validation...A Multiple of a number

In the validation criteria, select Custom from the Allow list, and
enter

=MOD(A1,50)=0

in the Formula box (change A1 to whichever cell you're putting the
validation on). If a user tries to enter a value which isn't a multiple
of 50 they'll get an error.

Hope that helps
Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=558426

Reply With QuoteReply With Quote