Round a number

[Dervish]

Hello,

How do I convert these numbers from:

28.6667
34.3333
25.8215
10.1235
etc...

to:

28.5
34.5
26
10

I can only have a number with either .5 or rounded to a nearest whole number.

Thanks in advance.

 

[Peo Sjoblom]

You can use a help column and a formula like

=ROUND(A1/0.5,0)*0.5

Regards,

Peo Sjoblom

 

[Alex Delamain]

very neat.......but simpler still is

=mround(a1,0.5

 

[Frank Kabel]

Hi
=ROUND(A1*2,0)/2

Also see:
http://www.xldynamic.com/source/xld.Rounding.html

 

[Frank Kabel]

Hi
but this would require the ATP which might n ot be installed ))

 

[Peo Sjoblom]

True but it's part of the Analysis Toolpak and I always try to avoid if
possible to use formulas
from there since it's not always installed, for instance I don't have it
installed at my present work

Regards,

Peo Sjoblom

 

[Ron Rosenfeld]

very neat.......but simpler still is

=mround(a1,0.5)

You do have to have the Analysis Tool Pak installed in order to use this
function.


--ron

 

[Dervish]

very neat.......but simpler still is

=mround(a1,0.5)

Thank you, Alex.

Your formula: =mround(a1,0.5)works perfectly for my project.

Thanks to all of you for the input.

Dervish

 

[JE McGimpsey]

Just note that MROUND() is a function from the Analysis Toolpak Add-in.
If your project requires you to publish your workbook to others, they
will get #NAME! errors unless they also have the add-in installed.