Thanks to both of you, I had tried the =ROUND(a1,0.5) but it just gave me an
error, so I'll try either of the methods you mentioned, thanks again!!!

"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