=ROUND(A20*2,0)/2

--
__________________________________
HTH

Bob

"Warren Easton" wrote in message
...
Can someone help please?
Is it possible to round up or down to the nearest 0.5
For example 6.2 would round to 6 and 6.3 would round to 6.5.

Thanks in advance.
--
Regards
Warren