Is the ROUND() function broken?

There is a very serious issue with the ROUND() function in SmartSuite formulas. If I round numbers to 2 decimal places, there are completely inconsistent values reported. Any number ending in .425 should round to the same number .43, but this is not the case.

For instance, ROUND(31.425, 2) returns 31.43, but ROUND(32.425, 2) returns 32.42.

I created a SmartSuite app with 4000 lines. Starting with 5.425 and adding 5 on each line, I tested the ROUND() function and found that out of 4000 numbers, 489 of them calculated incorrectly, and at random groups along the number line. This result would be even worse if I upgrade my account and do the same test with 20,000 numbers.

This is a gigantic problem, I haven't encountered such a blatant problem with calculations and I use calculators from the dollar store. I need to track sales and am honestly a little terrified about continuing with SmartSuite if something so simple as a rounding calculation is this inconsistent.

SmartSuiteRoundingProblems.pdf
711.47KB
1
10 replies