Closed matrix4123 closed 1 year ago
The results are as expected.
Why would you expect rounding to a single decimal place to result in -3.4 rather than -3.3?
ROUND_HALF_UP
means round away from zero if the rounding digit is 5 or more, and in this case the rounding digit is 4.
I am trying to use the ROUND_HALF_UP method and seeing a strange result in certain scenarios:
I would expect rounding to a single decimal place would result in -3.4 but is returning -3.3. If I do the rounding twice, I can arrive at -3.4 though.
Any ideas?