error subtraction exel

[washington]

Hi
Exel when it executes a subtraction between cells, returns a wrong number
after 12ª house decimal. For example: 22,02 - 22 =
0,019999999999999600000000000000 If to modify for final pairs, that is:
22,04; 22,06 and 22,08 the error is for minor. If to modify for odd ends,
that is: 22,01; 22,03; 22,05; 11,07 and 22,09 the error is for greater.
I wait that it is corrected in the next updates?

Washington

 

[Gary''s Student]

This is normal roundoff error associated with floating point arithmetic. To
avoid this type of error use the ROUND() function.