You can used the MROUND function (ensure the Analysis tool pack add-in is
intalled).
i.e.
=MROUND(A1,0.5)
where A1 contains the amount to be rounded.
Hope that helps
___________________
Naz
London
"sueshe" wrote:
I have a list of numbers I am trying to round to the closest .50, can anyone
help me? ex. 264.68 would be 264.50; 264.97 would be 265.00
|