Forum Discussion
Excel bug incorrect calculation
same data different results, it is probably a floating point multiplication error but from paid enterprise application made to work with data I expected more
Excel:
Google Sheet:
Zoho:
OnlyOffice:
I guess same story will be with other spreadsheet software, at least for majority of it.
Actually =50*2.05 is bit less than 102.5. We may check by
=(50*2.05 -102.5)*1e10which returns -0.000142109 both for Excel and Google Sheet.
If unzip Excel, above number is kept as
<f>50*2.05</f><v>102.49999999999999</v>Power Query also return number less that 102.5
but Power Query uses banking rounding, i.e. to nearest even. If we add 1 in formula the number will be rounded to 104, not 103
MROUND rounds up if value is equal or greater than half of multiplier, otherwise rounds down.
But then why ROUND rounds correctly to nearest one and interestingly my google sheet shows correct result
