# Thread: Round to the nearest .125 (2000)

1. ## Round to the nearest .125 (2000)

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!

2. ## Re: Round to the nearest .125 (2000)

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

Steve

3. ## Re: Round to the nearest .125 (2000)

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.

4. ## Re: Round to the nearest .125 (2000)

Alternatively, you could use:

=ROUND(a1*8,0)/8

Cheers

5. ## Re: Round to the nearest .125 (2000)

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

6. ## Re: Round to the nearest .125 (2000)

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

7. ## Re: Round to the nearest .125 (2000)

Hey, thanks for the replies. Much appreciated.

Cheers!

8. ## Re: Round to the nearest .125 (2000)

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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•