| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding problem in excel
Can anyone tell me why when you enter this into a cell
=-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 The value comes out 2.32831E-10 when it should clearly be 0. I know I can format the cell to show as 0 but why does it ever show as 2.32831E-10 when it is impossible to have those numbers equal anything other then 0. Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding problem in excel
See this:
http://www.cpearson.com/Excel/rounding.htm Although the atricle mentions Excel 97 it's applicable to all versions of Excel. -- Biff Microsoft Excel MVP "EggMan903" wrote in message ... Can anyone tell me why when you enter this into a cell =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 The value comes out 2.32831E-10 when it should clearly be 0. I know I can format the cell to show as 0 but why does it ever show as 2.32831E-10 when it is impossible to have those numbers equal anything other then 0. Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding problem in excel
Thank you for your response.
Unfortunately there are no formulas in the excel that I am referencing. I just typed in those 8 numbers, added them up, and got that answer. You could also type in =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 and you will get the answer of 2.32831E-10. It is currently formated to general and I know I can format it to number and it would show as 0 but why does it show as that value to begin with. "T. Valko" wrote: See this: http://www.cpearson.com/Excel/rounding.htm Although the atricle mentions Excel 97 it's applicable to all versions of Excel. -- Biff Microsoft Excel MVP "EggMan903" wrote in message ... Can anyone tell me why when you enter this into a cell =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 The value comes out 2.32831E-10 when it should clearly be 0. I know I can format the cell to show as 0 but why does it ever show as 2.32831E-10 when it is impossible to have those numbers equal anything other then 0. Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding problem in excel
Unfortunately there are no formulas in the excel that I am referencing.
What do you think this is: =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 It *is* a formula. See what Microsoft has to say about it: (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 How to correct rounding errors in floating-point arithmetic http://support.microsoft.com/kb/214118 -- Biff Microsoft Excel MVP "EggMan903" wrote in message ... Thank you for your response. Unfortunately there are no formulas in the excel that I am referencing. I just typed in those 8 numbers, added them up, and got that answer. You could also type in =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 and you will get the answer of 2.32831E-10. It is currently formated to general and I know I can format it to number and it would show as 0 but why does it show as that value to begin with. "T. Valko" wrote: See this: http://www.cpearson.com/Excel/rounding.htm Although the atricle mentions Excel 97 it's applicable to all versions of Excel. -- Biff Microsoft Excel MVP "EggMan903" wrote in message ... Can anyone tell me why when you enter this into a cell =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 The value comes out 2.32831E-10 when it should clearly be 0. I know I can format the cell to show as 0 but why does it ever show as 2.32831E-10 when it is impossible to have those numbers equal anything other then 0. Thank you |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding problem in excel
I apologize T. Valko
After reading that article a little more in depth I can see the part about Floating Point Numbers and that seems to be the problem I am having. Thank you "EggMan903" wrote: Thank you for your response. Unfortunately there are no formulas in the excel that I am referencing. I just typed in those 8 numbers, added them up, and got that answer. You could also type in =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 and you will get the answer of 2.32831E-10. It is currently formated to general and I know I can format it to number and it would show as 0 but why does it show as that value to begin with. "T. Valko" wrote: See this: http://www.cpearson.com/Excel/rounding.htm Although the atricle mentions Excel 97 it's applicable to all versions of Excel. -- Biff Microsoft Excel MVP "EggMan903" wrote in message ... Can anyone tell me why when you enter this into a cell =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 The value comes out 2.32831E-10 when it should clearly be 0. I know I can format the cell to show as 0 but why does it ever show as 2.32831E-10 when it is impossible to have those numbers equal anything other then 0. Thank you |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding problem in excel
You must have posted this before my last post went up. I realized the article
you sent me was very helpful. Thank you very much "T. Valko" wrote: Unfortunately there are no formulas in the excel that I am referencing. What do you think this is: =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 It *is* a formula. See what Microsoft has to say about it: (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 How to correct rounding errors in floating-point arithmetic http://support.microsoft.com/kb/214118 -- Biff Microsoft Excel MVP "EggMan903" wrote in message ... Thank you for your response. Unfortunately there are no formulas in the excel that I am referencing. I just typed in those 8 numbers, added them up, and got that answer. You could also type in =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 and you will get the answer of 2.32831E-10. It is currently formated to general and I know I can format it to number and it would show as 0 but why does it show as that value to begin with. "T. Valko" wrote: See this: http://www.cpearson.com/Excel/rounding.htm Although the atricle mentions Excel 97 it's applicable to all versions of Excel. -- Biff Microsoft Excel MVP "EggMan903" wrote in message ... Can anyone tell me why when you enter this into a cell =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 The value comes out 2.32831E-10 when it should clearly be 0. I know I can format the cell to show as 0 but why does it ever show as 2.32831E-10 when it is impossible to have those numbers equal anything other then 0. Thank you |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding problem in excel
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "EggMan903" wrote in message ... You must have posted this before my last post went up. I realized the article you sent me was very helpful. Thank you very much "T. Valko" wrote: Unfortunately there are no formulas in the excel that I am referencing. What do you think this is: =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 It *is* a formula. See what Microsoft has to say about it: (Complete) Tutorial to Understand IEEE Floating-Point Errors http://support.microsoft.com/kb/42980 How to correct rounding errors in floating-point arithmetic http://support.microsoft.com/kb/214118 -- Biff Microsoft Excel MVP "EggMan903" wrote in message ... Thank you for your response. Unfortunately there are no formulas in the excel that I am referencing. I just typed in those 8 numbers, added them up, and got that answer. You could also type in =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 and you will get the answer of 2.32831E-10. It is currently formated to general and I know I can format it to number and it would show as 0 but why does it show as that value to begin with. "T. Valko" wrote: See this: http://www.cpearson.com/Excel/rounding.htm Although the atricle mentions Excel 97 it's applicable to all versions of Excel. -- Biff Microsoft Excel MVP "EggMan903" wrote in message ... Can anyone tell me why when you enter this into a cell =-187992-213510-828672.8-1025000+828672.8+213510+1025000+187992 The value comes out 2.32831E-10 when it should clearly be 0. I know I can format the cell to show as 0 but why does it ever show as 2.32831E-10 when it is impossible to have those numbers equal anything other then 0. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding customer logo jpg to excel 2007 spreadsheet problem | Excel Discussion (Misc queries) | |||
| Problem in adding the Column | Excel Discussion (Misc queries) | |||
| Adding problem | Excel Discussion (Misc queries) | |||
| cells adding problem | New Users to Excel | |||
| problem adding | Excel Discussion (Misc queries) | |||
Linear Mode
