Excel returning an incorrect total
 

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.

Excel returning an incorrect total
 

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

"ETC" wrote:

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.

Excel returning an incorrect total
 

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

Jim Thomlinson


"ETC" wrote:

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.