Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is there 0.01 difference when I set up sum function in excel?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is there 0.01 difference when I set up sum function in excel?
On Oct 23, 8:51*pm, Question wrote:
Subject: Why is there 0.01 difference when I set up sum function in excel? Without details, we can only speculate. A common cause of small differences is the fact that few numbers can be represented exactly in Excel, which relies on binary computer arithmetic. This is especially true when the individual values are the result of other computations. Another common cause is mistaking the displayed value for the true value. Even if the displayed value appears rounded to 2 decimal places, the actual value in the cell might be computed to more decimal places. In both cases, the remedy is the liberal use of the ROUND function; for example, =ROUND(100/3,2); and =ROUND(SUM(A1:A10),2), even if each of A1:A10 has been rounded. Does this help? PS: In the future, please repeat your question in the body of your posting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a conditional function to sum the difference between two col | Excel Discussion (Misc queries) | |||
difference between a private sub and a public function? | Excel Discussion (Misc queries) | |||
Networkdays function doesn't find true difference between two dat | Excel Worksheet Functions | |||
Excel function to find difference of timestamps in milliseconds? | Excel Discussion (Misc queries) | |||
sumif function with a difference | Excel Worksheet Functions |