=CEILING(A1,0.5)
--
If this post helps click Yes
---------------
Jacob Skaria


"Arceedee" wrote:

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