| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| year formula returning incorrect value | Excel Worksheet Functions | |||
| Incorrect Total in Excel 2007 | Excel Worksheet Functions | |||
| Cell reference returning incorrect value | Excel Discussion (Misc queries) | |||
| Lookup returning incorrect value | Excel Discussion (Misc queries) | |||
| SUMPRODUCT returning incorrect result | Excel Worksheet Functions | |||
Hybrid Mode
