Or without the Analysis tool pack add-in try:
=ROUND(A1*2,0)/2
HTH
Sandy
--
to e-mail direct replace @mailintor.com with @tiscali.co.uk
"sueshe" wrote in message
...
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
|