ROUND UP or DOWN by 0.5

[Warren Easton]

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.

 

[Bob Phillips]

=ROUND(A20*2,0)/2

 

[Warren Easton]

Perfect, Thank You.--

Regards
Warren

=ROUND(A20*2,0)/2

 

[David Biddulph]

=MROUND(A2,0.5)
Look up MROUND in Excel help if you have problems.