Rounding numbers to nearest 0.12

  • Thread starter Thread starter Rick Sanderson
  • Start date Start date
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
 
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
 
If you'd rather not depend on the Analysis Toolpak Add-in, you could
use:

=ROUND(A1*8,0)/8
 
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
 
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.
 
Back
Top