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

user_13482310 0
Viewed 54

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

google-sheets-formula formula google-sheets floating-point
1 Answers

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)

enter image description here

user_56326290
Related