go to data-- validation--Custom
and enter the following
=MOD(A1,0.125)=0
Now any time you enter values in cell A1 that is not a 1/8 it will give an
error message

Or if you want a function to check
=if(mod(a1,0.125)<0,"Not 1/8th","1/8th")



"ynissel" wrote in message
...
is there a function I can write to check if a different cell is rounded to
the
nearest 1/8th or can I make validation make sure the cell is entered to an
1/8th