On Thu, 22 Jun 2006 16:10:17 -0500, L.sean9
wrote:


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