Rounding to the Nearest Eighth
 

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


--
L.sean9
------------------------------------------------------------------------
L.sean9's Profile: http://www.excelforum.com/member.php...o&userid=35681
View this thread: http://www.excelforum.com/showthread...hreadid=554767

Rounding to the Nearest Eighth
 

=mround(a1,0.125)


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=554767

Rounding to the Nearest Eighth
 

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

Rounding to the Nearest Eighth
 

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


"L.sean9" wrote
in message :

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


--
L.sean9
------------------------------------------------------------------------
L.sean9's Profile: http://www.excelforum.com/member.php...o&userid=35681
View this thread: http://www.excelforum.com/showthread...hreadid=554767

Rounding to the Nearest Eighth
 

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