software

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


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: www.excelforum.com/member.php...oamp;userid=30736
View this thread: www.excelforum.com/showthread...hreadid=522613You'll need to wrap the existing formulas in column with the ROUND()
function, like so for cell C2

=ROUND(B2/exchange rate,2)
quot;Ozgur Tunaquot; wrote:

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

www.mcgimpsey.com/excel/pennyoff.html

--
Kind regards,

Niek Otten

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