LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ozgur Tuna
 
Posts: n/a
Default Auto Sum and decimilization

I have a spreadsheet with four columns A to D, where C is the result of a
value that is a division of the value in B by the monthly Rate of Exchange.
We defined the value in C as having two decimals. The value in D is the
addition of A, B and C. When we add up the values in D column, we don't
obtain an exact result. There is always a difference of a few cents. By the
way, there are more than a hundred rows that we are adding up. We believe
that this is something to do with the decimilization of column C which we
formatted to two decimal points but although we do not see a value more than
this, the total addition picks up more decimal points.

We will be grateful of any new ideas!

Regards,

Ozgur Tuna
 
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



All times are GMT +1. The time now is 12:52 PM.

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

About Us

"It's about Microsoft Excel"