Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |