title: Excel doesn't calculate simple arithmetic operations correctly
body: <p>I have a table in Excel with two colymns: <code>A</code> and <code>B</code>. Column <code>B</code>, starting from the second row, takes a value from <code>B</code> column, one row higher and subtracts value from column <code>A</code> from one row higher from it.</p>
  
  <pre><code>332 406 053,41    |   3 300 000 000,00
  0,00              |   2 967 593 946,59
  0,00              |   2 967 593 946,59
  0,00              |   2 967 593 946,59
  0,00              |   2 967 593 946,59
  0,00              |   2 967 593 946,59
  0,00              |   2 967 593 946,59
  0,00              |   2 967 593 946,59
  0,00              |   2 967 593 946,59
  110 802 017,80    |   2 967 593 946,59
  110 802 017,80    |   2 856 791 928,79
  110 802 017,80    |   2 745 989 910,99
  0,00              |   2 635 187 893,19
  585 597 309,59    |   2 635 187 893,19
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  0,00              |   2 049 590 583,60
  55 634 374,57     |   2 049 590 583,60
  55 634 374,57     |   1 993 956 209,03
  55 634 374,57     |   1 938 321 834,46
  55 634 374,57     |   1 882 687 459,88
  55 634 374,57     |   1 827 053 085,31
  55 634 374,57     |   1 771 418 710,74
  55 634 374,57     |   1 715 784 336,17
  55 634 374,57     |   1 660 149 961,60
  55 634 374,57     |   1 604 515 587,03
  55 634 374,57     |   1 548 881 212,46
  55 634 374,57     |   1 493 246 837,89
  55 634 374,57     |   1 437 612 463,32
  55 634 374,57     |   1 381 978 088,75
  55 634 374,57     |   1 326 343 714,17
  55 634 374,57     |   1 270 709 339,60
  55 634 374,57     |   1 215 074 965,03
  55 634 374,57     |   1 159 440 590,46
  55 634 374,57     |   1 103 806 215,89
  55 634 374,57     |   1 048 171 841,32
  55 634 374,57     |   992 537 466,75
  55 634 374,57     |   936 903 092,18
  55 634 374,57     |   881 268 717,61
  55 634 374,57     |   825 634 343,04
  769 999 968,47    |   769 999 968,47
  0,00              |   -0,0000010729
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/pbuVZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pbuVZ.png" alt="enter image description here"></a></p>
  
  <p>Sum in column <code>A</code> is equal to a value in <code>B1</code>. However, in the end the last row of <code>B</code> isn't equal to 0. It's less than zero and is a float number.</p>
  
  <p>How is that possible and how to get zero after all the substraction? I've done similar calculations previously with no problem.</p>