Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2006

Tip: Looking for answers? Try searching our database.

Auto Sum and decimilization

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ozgur Tuna - 15 Mar 2006 14:19 GMT
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
EdMac - 15 Mar 2006 14:33 GMT
Hi Ozgur,

Formatting to 2 decimal places only effects what you see - the 'real
value remains as calculated.  If you use the ROUND function then wha
you see is what you have.

HtH

E
Duke Carey - 15 Mar 2006 14:37 GMT
You'll need to wrap the existing formulas in column with the ROUND()
function, like so for cell C2

=ROUND(B2/exchange rate,2)

> 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.
[quoted text clipped - 11 lines]
>
> Ozgur Tuna
Niek Otten - 15 Mar 2006 14:39 GMT
http://www.mcgimpsey.com/excel/pennyoff.html

Signature

Kind regards,

Niek Otten

>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.
[quoted text clipped - 11 lines]
>
> Ozgur Tuna
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.