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
|