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

If this post helps click Yes
---------------
Jacob Skaria


"David Biddulph" wrote:

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

Jacob Skaria wrote:
=CEILING(A1,0.5)

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