"duketter" wrote:
I would like my cell to either round to the nearest
whole num or ".5" of the number but it needs to
round down.

Ostensibly, you want to round down to the nearest 0.5. Try:

=ROUNDDOWN(A1*2,0)/2

Caveat: "what you see is NOT what you get" always. For example, if A1 is
formatted as Number with 1 decimal place, and the value is 5.95, you will see
6.0, but the ROUNDDOWN expression above will result in 5.5. If that is
unacceptable, then perhaps you want:

=ROUNDDOWN(ROUND(A1,1)*2,0)/2


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

"duketter" wrote:

I am using Excel 2007 and need some helping on a rounding formula. I would
like my cell to either round to the nearest whole num or ".5" of the number
but it needs to round down. For example:

5.1 would round to 5.0
5.4 would round to 5.0
5.5 would round to 5.5
5.7 would round to 5.5
5.9 would round to 5.5
6.0 would round to 6.0

I am using the Mround function but that rounds up so 5.8 and 5.9 rounds to
6.0 but I need them both to round to 5.5.

Any thoughts? Thanks!