Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the sum formula is not adding correctly?
The additon in my formula is not adding correctly. When trying to add one
cell(1348.86) to another(556.86) it is equaling 1905.71 but the correct answer is 1905.72 Can anyone explain why this is happening and how to fix it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the sum formula is not adding correctly?
Are 1348.86 and 556.86 calcuated from other cells?
If so, it sounds like you probably have cell format set to Number with a two decimal place limit. If this is indeed the case you are probably experiencing a rounding fudge factor "error." For example, if I enter the following into cells formatted to only two decimals: A1 B1 C1 10.505 10.505 =A1+B1 I get... A1 B1 C1 10.51 10.51 21.01 But 10.51 + 10.51 = 21.02 Just a FWIW.. "justmeamw70" wrote: The additon in my formula is not adding correctly. When trying to add one cell(1348.86) to another(556.86) it is equaling 1905.71 but the correct answer is 1905.72 Can anyone explain why this is happening and how to fix it? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the sum formula is not adding correctly?
Thank you, that was exactly what was going on. I appreciate your time!
"Stephen Lloyd" wrote: Are 1348.86 and 556.86 calcuated from other cells? If so, it sounds like you probably have cell format set to Number with a two decimal place limit. If this is indeed the case you are probably experiencing a rounding fudge factor "error." For example, if I enter the following into cells formatted to only two decimals: A1 B1 C1 10.505 10.505 =A1+B1 I get... A1 B1 C1 10.51 10.51 21.01 But 10.51 + 10.51 = 21.02 Just a FWIW.. "justmeamw70" wrote: The additon in my formula is not adding correctly. When trying to add one cell(1348.86) to another(556.86) it is equaling 1905.71 but the correct answer is 1905.72 Can anyone explain why this is happening and how to fix it? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why is the sum formula is not adding correctly?
On Jun 30, 11:44*am, justmeamw70
wrote: The additon in my formula is not adding correctly. When trying to add one cell(1348.86) to another(556.86) it is equaling 1905.71 but the correct answer is 1905.72 Can anyone explain why this is happening and how to fix it? Since you want the sum of the __displayed__ values, which are rounded to 2 places apparently by format, you could do the following: =round(A1,2) + round(A2,2) You can also set the option to calculate Precision As Displayed (Tools Options Calculation in Excel 2003). Generally I discourage the use of that option because it can have some surprising results. If you tend to round results in intermediate cells (A1 and A2), you might get away with =A1+A2. But even then, I prefer to do =round(A1+A2,2). That ensures that the internal representation is the same as if the displayed value were entered directly. That ensures that two cells with the same displayed value will compare equal. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why are my columns not adding correctly | Excel Worksheet Functions | |||
Row of numbers not adding correctly | Excel Discussion (Misc queries) | |||
Numbers not adding together correctly | Excel Worksheet Functions | |||
Excel is not adding up figures correctly | Excel Discussion (Misc queries) | |||
adding days correctly | Excel Worksheet Functions |