Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
when I use the Sum function to calculate about 10,000 numbers, which have
been rounded to 2 decimals (using the round function in excel), the result of sum came out with more than 2 decimals. It is eight decimals! I don't know why, and I split the numbers into several groups. I find that an interesting thing, the sum of Group A has two decimals, the same with Group B. But when I calculate the sum of the two groups, the result also came out with 8 decimals!!!... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003: spreadsheet / workbook extends to far to right. | Excel Discussion (Misc queries) | |||
type a sentence so it extends over grids | Excel Discussion (Misc queries) | |||
CTRL+SHIFT+END extends selection of cells to last - how reset? | Excel Discussion (Misc queries) | |||
Function to ignore decimals | Excel Worksheet Functions | |||
a function on decimals | Excel Worksheet Functions |