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