05-13-2022, 10:49 AM
(05-13-2022, 01:08 AM)bplus Wrote:(05-13-2022, 12:45 AM)dcromley Wrote: > bplus: "Luke explained it as bankers rounding, so that not every 5 is rounded up but every other 5 is."
Yes, it is (now) clear that _ROUND rounds n.5 up if n is odd and down if n is even.
Int(n.5) always rounds n.5 up. SMcNeill's Round##(n.5,0) also always rounds up.
> aural: "Round() function always round to lower value"
Wha--?
I'm sure just a mis-word but INT() always rounds down for positives anyway.
BTW that's another crazy issue to worry about, rounding with negatives. I'm not sure you always want to add .5 in SMcNeill's Round##()
If not,then add * SGN(num) after that 0.5. Tweak the behavior to whatever suits your personal needs/desires.