Rounding

[Arceedee]

Im trying to round a number to the nearest 0.5 either up or down. Example:
3.2 becomes 3.0 or 3.4 becomes 3.5.

Please help. I'm getting so frustrated with something that should be simple.

Thanks

 

[JoeU2004]

Im trying to round a number to the nearest 0.5 either up or down.

=mround(A1,0.5)

If you get a #NAME error, see the Help page for MROUND. Alternatively,
either of the following:

=round(A1/0.5,0)*0.5

=round(A1*2,0)/2


----- original message -----

 

[Jacob Skaria]

=CEILING(A1,0.5)

 

[David Biddulph]

=MROUND(A1,0.5)
In case of problems, read Excel help for the MROUND function.

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

 

[David Biddulph]

Won't that always round UP, rather than to the nearest, Jacob?
3.2 goes to 3.5, not 3.0 as requested.

 

[Jacob Skaria]

Thanks. During the initial reding "either up or down" caught my mind/.

If this post helps click Yes