Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |