Rounding towards zero or from zero
6 views (last 30 days)
Hi all; I want to round 3.6 to 3 but funny enough all the 'tozero' and 'fromzero' tiebreakers are returning the same answer i.e 4 which i dont want. How can this issue be fixed?
More Answers (3)
Steven Lord on 26 Sep 2022
The tiebreaker methods only apply when the quantity to be rounded is halfway between the two numbers to which it could be rounded. So if you had 3.5 that's halfway between 3 and 4 and the tiebreaker would determine to which of those numbers 3.5 gets rounded.
round(3.5, 'TieBreaker', 'tozero')
round(3.5, 'TieBreaker', 'fromzero')
There's no tie to be broken if you're rounding 3.6.
There are other rounding functions that you may want to use instead of round. See their help or documentation pages for more information on each function's specific behavior.
[fix(3.6), floor(3.6), round(3.6), ceil(3.6)]