rounding to .5

[Jean-Paul De Winter]

Hi,

I want a value like 4.4 to be rounded to 4.5 upon entering
Values like:
6.1 should be 6
4.6 should be 4.5
4.8 should be 5

Any idea?

it should be invoked when leaving the corresponding cell...

Thanks

 

[Don Guillett]

=ROUND(C13*2,0)/2
to have it automatic>right click sheet tab>view code>copy/paste this>modify
to suit>save

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 3 Then Exit Sub'restricted to col C
Target.Value = Round(Target * 2, 0) / 2
End Sub