| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=SUM returns 5.54365E-11 instead of 0 (zero)
I have a set of journal data extracted from SQL Server 2005 and paste them
in Excel 2003, the net result of this set of number should produce 0, instead in the cell that I use the =SUM() function, it produced "5.54365E-11" How come? I could format the cell using "Number" which gaved me "0" but I am just wondering why? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell with value returns that value, empty cell returns zero | Excel Worksheet Functions | |||
| SumProduct Returns Zero | Excel Worksheet Functions | |||
| sum returns #N/A | Excel Worksheet Functions | |||
| Formula returns 0 | Excel Worksheet Functions | |||
| How to do nothing if @IF returns FALSE? | Excel Worksheet Functions | |||
Threaded Mode
