Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 791
Default Excel is not adding up figures correctly

I cannot get sums to add up correctly. Whenever I have the sum of few cells
being multiplied by a certain amount, the answer is off by a few decimal
points. It is driving me mad. Please help.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default Excel is not adding up figures correctly

You may simply need to display more decimal points to be certain what is
being multiplied. Try showing 5/6 decimal places in all your cells .

Can you give an example?

"Michael" wrote:

I cannot get sums to add up correctly. Whenever I have the sum of few cells
being multiplied by a certain amount, the answer is off by a few decimal
points. It is driving me mad. Please help.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Running Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 06:04 PM
Using Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 02:36 AM
Excel does not display entered values correctly TSL1050 Excel Discussion (Misc queries) 2 January 17th 06 04:00 AM
Add-in correctly deleted in Excel but still showing up in MSIE ?????????? WMB Excel Discussion (Misc queries) 1 July 27th 05 12:46 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"