error subtraction exel

  • Thread starter Thread starter washington
  • Start date Start date
W

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
 
This is normal roundoff error associated with floating point arithmetic. To
avoid this type of error use the ROUND() function.
 
Back
Top