PC Review


Reply
Thread Tools Rate Thread

Addition of 2 cells is not correct

 
 
MAX
Guest
Posts: n/a
 
      18th Feb 2009
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.
 
Reply With Quote
 
 
 
 
David Biddulph
Guest
Posts: n/a
 
      18th Feb 2009
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" <(E-Mail Removed)> wrote in message
news:913B74AB-CD90-4A88-B9BD-(E-Mail Removed)...
> 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.



 
Reply With Quote
 
Pete_UK
Guest
Posts: n/a
 
      18th Feb 2009
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...@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.


 
Reply With Quote
 
Mike H
Guest
Posts: n/a
 
      18th Feb 2009
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Addition function of multiple cells DB74 Microsoft Excel Misc 10 28th May 2010 08:55 PM
Conditional addition of cells ceab Microsoft Excel Discussion 5 7th Jan 2010 06:44 PM
Addition of cells involving rounding =?Utf-8?B?Tmljaw==?= Microsoft Excel Misc 6 1st Feb 2007 03:32 PM
Spacing in cells is preventing addition =?Utf-8?B?S3Jpcw==?= Microsoft Excel Worksheet Functions 0 9th Sep 2006 03:41 PM
Quick addition in cells Uberman Microsoft Excel Discussion 2 31st Aug 2004 09:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:04 AM.