Addition of 2 cells is not correct

MAX · External Since: Dec 10, 2004 Posts: 11

Cell O30 is the sum of such cells ----- â‚¬ 1183.825
Cell O53 is the sum of such cells ------ â‚¬ 743.990
Cell O56 is the sum of O30 and O53 and the answer is coming â‚¬ 1927.814
instead of â‚¬ 1927.815
All the 3 cells are in currency and to 3 decimal places.
Why the answer is coming with a difference of .001

Thanks for your help.

Pete_UK · External Since: Apr 17, 2007 Posts: 380

Increase the number of decimal places displayed in cells O30 and O53,
and you will see why. The displayed value is an approximation of the
real underlying value. Use ROUND( ... ,3) in your formulae to avoid
these errors.

Hope this helps.

Pete

On Feb 18, 12:26 pm, MAX <M....RemoveThis@discussions.microsoft.com> wrote:
> Cell O30 is the sum of such cells ----- € 1183.825
> Cell O53 is the sum of such cells ------ € 743.990
> Cell O56 is the sum of O30 and O53 and the answer is coming € 1927.814
> instead of € 1927.815
> All the 3 cells are in currency and to 3 decimal places.
> Why the answer is coming with a difference of .001
>
> Thanks for your help.

Mike H · External Since: May 24, 2006 Posts: 1059

Hi,

Look here to find out why

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

Mike

"MAX" wrote:

> Cell O30 is the sum of such cells ----- â‚¬ 1183.825
> Cell O53 is the sum of such cells ------ â‚¬ 743.990
> Cell O56 is the sum of O30 and O53 and the answer is coming â‚¬ 1927.814
> instead of â‚¬ 1927.815
> All the 3 cells are in currency and to 3 decimal places.
> Why the answer is coming with a difference of .001
>
> Thanks for your help.

David Biddulph · External Since: Feb 24, 2007 Posts: 1283

I guess that you mean that you have DISPLAYED the cells to 3 decimal places,
but that that the underlying numbers have more places? You can check by
temporarily reformatting with more places.
You may want =ROUND(O30,3)+ROUND(O53,3)
--
David Biddulph

"MAX" <MAX DeleteThis @discussions.microsoft.com> wrote in message
news:913B74AB-CD90-4A88-B9BD-F4AFF9E95964@microsoft.com...
> Cell O30 is the sum of such cells ----- ? 1183.825
> Cell O53 is the sum of such cells ------ ? 743.990
> Cell O56 is the sum of O30 and O53 and the answer is coming ? 1927.814
> instead of ? 1927.815
> All the 3 cells are in currency and to 3 decimal places.
> Why the answer is coming with a difference of .001
>
> Thanks for your help.