rounding error
 

How can I restrict a cell so that it will only accept whole numbers between 1
and 24, or a decimal number between .25 and 23.75? The decimal answers can
only be .25, .5 or .75?


--
Thanks
Shawn

rounding error
 

Shawn,

in the data validation select 'custom' and in the formula type
=AND(4*A10, 4*A1<=96,4*A1=INT(4*A1))

This formula applies to cell A1. You will need to extrapolate for other
cells.

Good luck
Fred

"Shawn" wrote in message
...
How can I restrict a cell so that it will only accept whole numbers
between 1
and 24, or a decimal number between .25 and 23.75? The decimal answers
can
only be .25, .5 or .75?


--
Thanks
Shawn