# Thread: Round to nearest .125 (2000)

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

Hi All

I have a spreadsheet that calculates a numeric value to 4 decimal places.
eg: 48.6574, 92.2556, 168.8695

Can anyone tell me how I can round the result to the nearset '.125'?
eg: 48.625, 92.250, 168.875

Have a Great day!!!
Ken

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

See <post:=508,524>post 508,524</post:>

Steve

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

Hi Steve

<img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> <img src=/S/blush.gif border=0 alt=blush width=15 height=15> I did a search but that thread didn't come up. I guess my criterea wasn't too good.

Thanks a lot!

Have a Great day!!!
Ken

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

Hi Steve

hmmmmmm....not working for me, neither solution.
Both suggestions:
86.1932 gives me 86.19375
86.193 still gives me 86.19375
I need the result '86.250'

Have a Great day!!!
Ken

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

The formula in the post Steve pointed you to is working with percents, so it needs to be modified a bit to work with numbers. Try:

[post]
=ROUND(A1*8,0)/8
[/post]

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

OK

It seems to work if I remove the '%'.

Thanks again.

Have a Great day!!!
Ken

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

Hi
Thanks Legare. That works too.

Have a Great day!!!
Ken

#### Posting Permissions

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