Excel 100*2.2 <> 220 ??

Copper Contributor

Excel 100*2.2 <> 220

請檢查,差:2.8421709430404E-14

1 Reply

@hoihiowa 

We enter and view numbers in decimal notation, but Excel stores and processes numbers in binary notation. This causes unavoidable tiny rounding errors.

You can suppress these errors by rounding the result of your formulas, for example

 

=ROUND(100*2.2, 1)