Rounding of .5 not rounding upwards

Rounding of .5 not rounding upwards - Rounding of .5 not rounding upwards - Messages

#1 Posted: 3/10/2021 8:27:07 PM

0 likes in 4 posts.

Group: User

With rounding selected as half to even, the rounding doesn't round .5 up to 1.

For example, with decimal places set to 0:
2.50000 = 2
2.50001 = 3

This doesn't seem in line with the expectation that .5 rounds upwards and leaves some of my calculations looking misrepresentative on inspection. Same with the round function, which leaves something like 2.5 becoming 2, not 3.

Or is this intentional?

Thanks,

#2 Posted: 3/10/2021 8:46:04 PM

overlord

547 likes in 1330 posts.

Group: Moderator

This is intentional.
Please pay attention to description.
Half to even, it is rounding to even number.
Even numbers are 2,4,6,8...
Odd numbers are 1,3,5,7...

If decimal part of number is even then it round downward to its base.
If decimal part of number is odd, it round upwards.
If you want always round to up when fraction is equal or bigger than .5;
You have to use away from zero rounding option.

https://en.wikipedia.org/wiki/Rounding#Round_half_to_even

Regards

#3 Posted: 3/10/2021 9:44:42 PM

overlord

547 likes in 1330 posts.

Group: Moderator

Wrote
Same with the round function, which leaves something like 2.5 becoming 2, not 3.

round() function when used with two parameters always do rounding with half to even.
If you want away from zero option in round() function, add third parameter and make it 1.

Regards.