A cell or input with format 0.0% will render the number 0.0295 as 2.9% instead of 3.0%.
The problem is that, when using percentages, input number is scaled up by 100 and that produces floating point artifacts (0.0295 * 100 === 2.9499999999999997) that then mess up the rounding.
A cell or input with format
0.0%will render the number0.0295as2.9%instead of3.0%.The problem is that, when using percentages, input number is scaled up by 100 and that produces floating point artifacts (
0.0295 * 100 === 2.9499999999999997) that then mess up the rounding.