
4,397 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I stumbled about a funny behaviour of MROUND with Excel 2010: values very little below 0.5 times the 'significance divider' are not rounded down, but up.
E.g. '=MROUND( 5; 10 )' should round up per definitionem, 'midpoints away from zero', but '=MROUND( 4,999999999999999; 10 )' should not, it's below halfway, but does, result 10.
My questions:
was that known and is it somewhere documented?
is it still that way in newer Excel versions, or changed?
if changed: when and why, and where documented?
TIA for any help or hints.
b.