Rounding numbers to nearest 0.12

R

Rick Sanderson

Hi,
I need excel to round numbers to the nearest 1/8th,
2.6 becomes 2.62,
2.41 becomes 2.37 etc.

Can one of you gurus point me in the right direction.
Many thanks,
Rick
 
R

Rick Sanderson

Rick said:
Hi,
I need excel to round numbers to the nearest 1/8th,
2.6 becomes 2.62,
2.41 becomes 2.37 etc.

Can one of you gurus point me in the right direction.
Many thanks,
Rick
Click to expand...

MROUND job done
 
J

J.E. McGimpsey

If you'd rather not depend on the Analysis Toolpak Add-in, you could
use:

=ROUND(A1*8,0)/8
 
M

Myrna Larson

Check out the MROUND function, which is part of the Analysis Tool Pack (ATP). A 2nd argument of
1/8 will do what you want.

If you don't have the ATP loaded for other reasons, you can "roll your own"

=ROUND(A1*8,0)/8
 
R

Rick Sanderson

Myrna said:
Check out the MROUND function, which is part of the Analysis Tool
Pack (ATP). A 2nd argument of 1/8 will do what you want.

If you don't have the ATP loaded for other reasons, you can "roll
your own"

=ROUND(A1*8,0)/8
Click to expand...

Thanks JM&ML, i knew there was another way, i can stop racking my brain now.
 
Top