How do you set the data validation formula to limit entry to a multiple
of a number. My specific need is to have users enter only numbers that
are multiples of 50. I've been using a drop down list but the range is
getting really long now and it seems to me there must be an easier way
than a long drop down box. Anyone know how to create a formula from/in
the data validation options?
Dean

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

Dean,

Use Data / Validation... and choose "Custom" and use the formula:

=INT(A1/50)=A1/50

Replace the A1 with the current active cell's address.

HTH,
Bernie
MS Excel MVP


"Dean" wrote in message
oups.com...
How do you set the data validation formula to limit entry to a multiple
of a number. My specific need is to have users enter only numbers that
are multiples of 50. I've been using a drop down list but the range is
getting really long now and it seems to me there must be an easier way
than a long drop down box. Anyone know how to create a formula from/in
the data validation options?
Dean

Thank you! Perfect. All set.
Dean



colofnature wrote:
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