Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,388
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why does excel keeping rounding numbers babblings Excel Discussion (Misc queries) 3 February 1st 08 10:28 PM
Excel won't stop rounding numbers. Please help [email protected] Excel Discussion (Misc queries) 9 December 18th 06 08:38 PM
New rounding problem in Excel 2003?!? BethP Excel Discussion (Misc queries) 6 December 13th 06 11:20 PM
How do I stop numbers from rounding in Excel? Josette_N Excel Discussion (Misc queries) 10 January 27th 06 04:19 PM
Rounding off numbers in Excel 2003 Joe Tahoe Excel Worksheet Functions 4 July 28th 05 03:08 AM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"