floating point error in excel

Excel stores and calculates floating point numbers, but sometimes formula results are approximate.

1. For example, take a look at the formulas shown in the figure below. At first glance, everything looks good.
2. However, if we display 16 decimal places, we see that one of the results is a very approximate value.

   

   You don’t have to worry about the floating point problem. It is quite rare. Even if your sheet contains a floating point error, in most cases it doesn’t cause problems.

3. However, if you compare the value in a cell С8 with a different value, problems may appear.

   =IF(C8>=0.1,"Yes","No")

   =ЕСЛИ(C8>=0,1;"Yes";"No")

   

4. Use the function ROUND (ROUNDED) to fix it.

   =IF(ROUND(C8,1)>=0.1,"Yes","No")

   =ЕСЛИ(ОКРУГЛ(C8;1)>=0,1;"Yes";"No")