Rounding

A

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
 
J

JoeU2004

Arceedee said:
Im trying to round a number to the nearest 0.5 either up or down.
Click to expand...

=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 -----
 
D

David Biddulph

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

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

Jacob Skaria

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding to nearest 0.5 in Excel 2007 4
What do these numbers mean in the rounding formula? 2
Rounding to the nearest cent...currency values 3
Round formula 1
List values based on different values selected 15
Rounding to the Nearest Eighth 4
ROUNDING UP TO NEAREST 9 4
Rounding to Multiples of Integers? 5

Top