Only allow certain decimal numbers?

[merstevens]

I am trying to create a spreadsheet that only allows people to enter either whole numbers, or numbers ending in the decimals .25, .5, or .75. This is a spreadsheet that goes out blank, and gets sent back to me with information entered and if the correct decimal intervals aren't used, I have to recalculate them myself so I'm trying to build a spreadsheet that either doesn't allow the other decimal intervals, or that rounds them up automatically, and I can't figure out how to do it. Any suggestions? I thought maybe a custom data validation, but I can't figure out what the formula for that would be.

The spreadsheet is a timesheet that uses hour totals, not times, if that helps at all. In the image, I would need these limits to start in cell F12.

 

[ExceLoki]

from what it sounds like, this should work for you. it allows people to put in any number, but ti rounds each number up to the nearest .25
-------------------------

Book1
	F	G	H	I	J	K
3	0.75	0.68	0.55	0.25		2.5
Sheet1

Cell Formulas
Range	Formula
K3	K3	=SUM(CEILING(F3:I3,0.25))

 

[JoeMo]

Or if you want to use data validation for say cell A1 you can use this custom formula:

=OR(MOD($A1,1)=0,MOD($A1,1)=0.25,MOD($A1,1)=0.5,MOD($A1,1)=0.75)

 

[Fluff]

You can use data validation with a custom formula of

=F12=MROUND(F12,0.25)

 

[merstevens]

=OR(MOD($A1,1)=0,MOD($A1,1)=0.25,MOD($A1,1)=0.5,MOD($A1,1)=0.75)

This worked perfectly for me. Thank you so much!

 

[Fluff]

Did you try the formula I suggested?