"Arceedee" wrote:
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 -----

"Arceedee" wrote in message
...
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