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

Auto Sum and decimilization
 

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 what
you see is what you have.

HtH

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=522613

Auto Sum and decimilization
 

You'll need to wrap the existing formulas in column with the ROUND()
function, like so for cell C2

=ROUND(B2/exchange rate,2)



"Ozgur Tuna" wrote:

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

Auto Sum and decimilization
 

http://www.mcgimpsey.com/excel/pennyoff.html

--
Kind regards,

Niek Otten

"Ozgur Tuna" <Ozgur wrote in message ...
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