Excel returning an incorrect total

  • Thread starter Thread starter ETC
  • Start date Start date
E

ETC

When I add -2.1-0.2+2.8-0.5 which should = 0, excel returns -4.44089E-16. I
have tried this on two different spreadsheets, entering the exact values.
 
Hi,
Are you entering that numbers or ar a result of a formula, that results
means that you have decimals
 
That happens with decimals in computers. It is not exclusive to XL. Some
decimals do nto represent well in binary and as a result you get very tiny
errors. You just need to use a round function to get around it. For more info
search this site for IEEE who set the standards for computation in computers
and to which XL complies.
 
Back
Top