I got the following to do just what I wanted (kicks out less than 0, more
than 24, and anything that isn't on a quarter unit).

=IF(MOD(L1,0.25)<0,FALSE,IF(L1<0,FALSE,IF(L124,F ALSE,TRUE)))

--
Thanks
Shawn


"Ron Rosenfeld" wrote:

On Thu, 25 Feb 2010 10:49:01 -0800, Shawn
wrote:

Is there a way to have the cells validate to quarter units? Specifically, I
only want users to be able to enter .00; .25; .50; or .75 numbers.

Data/Validation/Settings

Custom
Formula: =MOD(A1,0.25)=0

--ron
.