Round to the nearest .125 (2000)

[Reorix]

I need to be able to have a worksheet round all numeric values to the nearest .125 on the decimal side. Any ideas as to how to go about this? Any help is appreciated!

[sdckapr]

If your value is in A1 you could use something like:
<pre>=INT(+A1*8+0.5)/8</pre>


Steve

[HansV]

1. Just for display: select the cells, then select Format | Cells..., Number tab, Fraction category, "As eighths (4/8)", OK.

2. To obtain rounded values with formulas:

If cell A2 contains a number, the formula =INT(A2*8+0.5)/8 in another cell will return the value rounded to the nearest multiple of 0.125 = 1/8.

[macropod]

Alternatively, you could use:

=ROUND(a1*8,0)/8

Cheers

[Errolv]

The Add-in called "Analysis ToolPak" (on your Office 200 installation disk) has the MROUND formula.

The format for your case is =MROUND(A1,0.125). Simple enough?

Errol

[sdckapr]

Thanks,
I will have to remember this function (It is also available in XL97)

I predict though, that when "push-comes-to-shove", I will probably forget it and go back to the old standby method.

Steve

[Reorix]

Hey, thanks for the replies. Much appreciated.

Cheers!

[macropod]

The biggest problem with using the ATP is that the formula doesn't work if the workbook is opened on a machine that where the ATP isn't loaded.

Cheers
PS: For ease of use, =ROUND(A1*8,0)/8 is equivalent to =ROUND(A1/0.125,0)*.125, just in case the unit of interest doesn't have a simple reciprocal.