Rounding to the Nearest Eighth

[L.sean9]

I have a problem with rounding down to the nearest eighth. For example:
100.334 and i need it to round to 100.25, I used some of the roundin
suggestions found on the forum but it's not the working. I also nee
the rounding work when it is a negative number. For Example: -.655 i
needs to round to -.625.
Thanks,
L.sean

 

[Bearacade]

=mround(a1,0.125

 

[Ron Rosenfeld]

=ROUND(A1*8,0)/8
--ron

 

[Jim May]

Here's another Way: With your original figures in Col A for (A1) -- in
B1 enter =IF(A1>0,FLOOR(A1,0.125),FLOOR(A1,-0.125))

 

[Ron Rosenfeld]

I have a problem with rounding down to the nearest eighth. For example:
100.334 and i need it to round to 100.25, I used some of the rounding
suggestions found on the forum but it's not the working. I also need
the rounding work when it is a negative number. For Example: -.655 it
needs to round to -.625.
Thanks,
L.sean9

I misread. To round down to the nearest eighth, you could use the rounddown
function:

=ROUNDDOWN(A1*8,0)/8

It gives your specified answers for your two examples.


--ron