Is there a better Google Sheets rounding/floating point error workaround?

Question

I have a Sheet that gives me a rounding error:

Rounding 0.415 to 2 places should result in 0.42, which it does when given the number directly. But the red line gives 0.41. The intermediate result before rounding is slightly less than 0.415, as shown in the second line.

The green line shows a workaround, which I guess I'll have to use throughout, unless anyone can suggest a better one. Any offers?

this is more of a floating point issue than a rounding one right? — MattKing, Feb 24 '22 at 21:08

score 1 · Answer 1 · answered Feb 24 '22 at 04:23

1

try:

=ROUNDUP((170.625-168.55)*0.2, 2)

answered Feb 24 '22 at 04:23

player0

124,011
12
67
124

Thanks, but that would round up everything, so even 0.4100001 would round to 0.42. – William Morris Feb 24 '22 at 13:22

Is there a better Google Sheets rounding/floating point error workaround?

1 Answers1