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

Shawn,

in the data validation select 'custom' and in the formula type
=AND(4*A1>0, 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" <Shawn@discussions.microsoft.com> wrote in message
news:5542200A-4BA6-4991-A0A8-C0F0BC9ECD52@microsoft.com...
> 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