Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
A more bullet-proof approach is given in
http://groups-beta.google.com/group/...7fce6145b70d69 As an example of the difference, try rounding =1110*0.0865 to 2 decimal places with microsoft's bround function and my ASTMround. Microsoft's bround will round 96.0150000000000 to 96.01, where my ASTMround will correctly round it to 96.02. Another example of the difference is referenced in that post. Jerry JE McGimpsey wrote: That type of rounding is very common in science, too, where it prevents a bias away from zero. There are many other flavors. See http://support.microsoft.com/default...b;en-us;196652 In article , "Bernard Liengme" wrote: I have seen this called Banker's Rounding, New Math rounding, Australian rounding. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function to Count Number of Consecutive Rows with a Specific Criteria? | Excel Worksheet Functions | |||
Round a number in nested function | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
The number change from 1350 to 13.5 and Enter does not function properly | Excel Discussion (Misc queries) |