In the 'round' function, what algo is being used by excel? like round(0.5, 0) gives result as '1'.
Should not it be '0' as per the IEC 60559 standard (i.e. go for the even digit)?
Thanks for your input.
In the 'round' function, what algo is being used by excel? like round(0.5, 0) gives result as '1'.
Should not it be '0' as per the IEC 60559 standard (i.e. go for the even digit)?
Thanks for your input.
Not having read the spec I can only say that Excel seems to conform to the mathematical definition of rounding.There is some discussion on this topic at the following https://stat.ethz.ch/pipermail/r-help/2009-March/190176.html.
_________________________________________________________________________
"In theory there is no difference between theory and practice. In practice there is." - Chuck Reid
Any day you learn something new is a day not wasted.
Depends on your standard and what Round you mean in Excel. In the US, most of us would round that up. I have seen even more rules to rounding than just those two basic ones.
Speaking of Excel, =round(0.5, 0) <> VBA's round(0.5, 0). In the VBE, put this in the Immediate window and press Enter key.
[VBA]round(0.5, 0)[/VBA]
Posting Permissions
Reply With Quote
