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