Why =IF(10.1-10=0.1,TRUE) returns F in Google sheets?

Question

What's the math behind this? Please explain. Thank you.

Because binary floating-point cannot always represent decimal numbers exactly. — a guest, Feb 07 '21 at 14:29
See https://stackoverflow.com/questions/588004/is-floating-point-math-broken — a guest, Feb 07 '21 at 14:30
And yet, `(10+0.1)=10.1` == `TRUE` ;) *(Still, use integers, or use `ROUND()`)* — MatBailie, Feb 07 '21 at 14:50

score 0 · Accepted Answer · answered Feb 07 '21 at 14:40

0

as mentioned, it's a floating-point issue so to get TRUE out of it you should do:

=IF(ROUND(10.1-10, 1)=0.1, TRUE)

answered Feb 07 '21 at 14:40

player0

1 Answers1