Limit data entry to 1/4" increments

[sriddle68]

I have a need to create a input sheet that only lets the user input
numbers in 1/4" increments like
33.00
33.25
33.50
33.75
50.25
22.75

NO 33.125 or 43.375 numbers.
Is there some way with data validation or other way? I tried cell
formating but it only displays it as a fraction. I want it to reject a
entry that does not equal a number on the quarter inch increment.

Thanks
Scott

 

[T. Valko]

Use Data Validation>Allow>Custom>Formula:

=MOD(A1,0.25)=0

 

[T. Valko]

Use Data Validation>Allow>Custom>Formula:

=MOD(A1,0.25)=0