Auto Sum and decimilization

[Ozgur Tuna]

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]

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]

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

=ROUND(B2/exchange rate,2)

 

[Niek Otten]

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