Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Excel rounding numbers
I have entered the exact same data into two different Excel worksheets and am
getting a different total in each when calculated. The cells are formatted as Numbers, no decimal with separator. In one place the result is 41,660 and the other is 41,657. Any ideas, help is appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Excel rounding numbers
Maybe you have some hidden rows. Use =countA(A1:A100) on both worksheets and
see if you are adding the same number of items. "Carol A" wrote: I have entered the exact same data into two different Excel worksheets and am getting a different total in each when calculated. The cells are formatted as Numbers, no decimal with separator. In one place the result is 41,660 and the other is 41,657. Any ideas, help is appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Excel rounding numbers
Thank you Joel. That was a good idea. That wasn't what was wrong but it
made me look at something else. One group of numbers were being summed and the other were a different calculation with a different result because of slight rounding differences. "Joel" wrote: Maybe you have some hidden rows. Use =countA(A1:A100) on both worksheets and see if you are adding the same number of items. "Carol A" wrote: I have entered the exact same data into two different Excel worksheets and am getting a different total in each when calculated. The cells are formatted as Numbers, no decimal with separator. In one place the result is 41,660 and the other is 41,657. Any ideas, help is appreciated. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Excel rounding numbers
Hi Joel,
If the cells have been formatted after data entry, it could still be text. In an adjacent column, test each cell with =ISTEXT(A2) (fill down) "Joel" wrote: Maybe you have some hidden rows. Use =countA(A1:A100) on both worksheets and see if you are adding the same number of items. "Carol A" wrote: I have entered the exact same data into two different Excel worksheets and am getting a different total in each when calculated. The cells are formatted as Numbers, no decimal with separator. In one place the result is 41,660 and the other is 41,657. Any ideas, help is appreciated. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Excel rounding numbers
1 What calculation are you doing, and what are the data values?
2 Does one of the worksheets have "Precision as Displayed" set? -- David Biddulph "Carol A" <Carol wrote in message ... I have entered the exact same data into two different Excel worksheets and am getting a different total in each when calculated. The cells are formatted as Numbers, no decimal with separator. In one place the result is 41,660 and the other is 41,657. Any ideas, help is appreciated. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Excel rounding numbers
"Carol A" wrote:
One group of numbers were being summed and the other were a different calculation with a different result because of slight rounding differences. So if you still wonder why ("problem with Excel rounding numbers") and would like an explanation, it would be helpful if you posted at least the two different formulas, as well as how you have the option "Precision as displayed" set. It would also be helpful to know the numbers involved. ----- original message ----- "Carol A" wrote in message ... Thank you Joel. That was a good idea. That wasn't what was wrong but it made me look at something else. One group of numbers were being summed and the other were a different calculation with a different result because of slight rounding differences. "Joel" wrote: Maybe you have some hidden rows. Use =countA(A1:A100) on both worksheets and see if you are adding the same number of items. "Carol A" wrote: I have entered the exact same data into two different Excel worksheets and am getting a different total in each when calculated. The cells are formatted as Numbers, no decimal with separator. In one place the result is 41,660 and the other is 41,657. Any ideas, help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why does excel keeping rounding numbers | Excel Discussion (Misc queries) | |||
Excel won't stop rounding numbers. Please help | Excel Discussion (Misc queries) | |||
New rounding problem in Excel 2003?!? | Excel Discussion (Misc queries) | |||
How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) | |||
Rounding off numbers in Excel 2003 | Excel Worksheet Functions |