Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet rounding vs VBA rounding
Excel 2K
The VBA Round function uses 'Bankers rounding' (half the time the .5 is rounded up, half the time down). The worksheet ROUND() function uses 'normal rounding' (.5 is always rounded up) Is there an easy way to make the VBA rounding the same as the worksheet rounding Thanks in advance Simon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
applying rounding formula to entire worksheet | Excel Worksheet Functions | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
rounding | Excel Discussion (Misc queries) | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) |