Excel returning an incorrect total

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.
 
E

Eduardo

Hi,
Are you entering that numbers or ar a result of a formula, that results
means that you have decimals
 
J

Jim Thomlinson

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.
 
Top