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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtract one cell from each cell in a range and count instances 2
Subtraction that doesn't produce an error 2
Subtracting Text from Number 6
Subtracting gives the wrong answer!! 2
Rounding Error when adding or subtracting two cells 2
strange error calculations provides errors until i add any new one 1
Subtracting Times 1
PRoble with subtraction 5

Back
Top