Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding to .5
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding to .5
=ROUND(C13*2,0)/2
to have it automaticright click sheet tabview codecopy/paste thismodify to suitsave 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 -- Don Guillett SalesAid Software "Jean-Paul De Winter" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
Need help with rounding | Excel Discussion (Misc queries) | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Worksheet rounding vs VBA rounding | Excel Programming |