View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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.