JP

use: =MROUND(A1,0.5)

Regards

Trevor


"Jean-Paul De Winter" wrote in message
...
Hi,
When a value is 60.12 I want it to be rounded to 60.00
a value 60.45 to 60.50
a value 60.57 to 60.50
a value 60.85 to 61.00
does somebody know s how?
Thanks
JP