LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Incorrect Total in Excel 2007

I have a spreadsheet which checks to see if a field has data in it and then
does a simple multiplication. Then I have a simple sum of all the results in
the results column. I have another set of numbers doing the same thing. The
results all seem to be perfect. The problem is when I add the two sums. I
get a number that appears to be incorrect. I know excel is binary and may
not 'see' the numbers as I see them but I'd like to know how to make it treat
the numbers literally and add them accordingly.

Here's a sample of the sheet:

COLUMN C (looks at one sheet and copies the value that has been data-entered):
=IF(ISBLANK('Finance Worksheet'!E2),"",'Finance Worksheet'!E2)


COLUMN D (fixed number data-entered)


COLUMN E (which has about 15-20 rows that either have or don't have numbers
in them):
=IF(ISNUMBER(C20),((C20*D20)/1000),)

and then further down in the column:
=SUM(E20:E34)

My subtotal is 5092.75.


COLUMN F (just like in column e):
=IF(ISNUMBER(D41),((D41*E41)/1000),)

and then further down in the column:
=SUM(F41:F79)

My subtotal is 3439.22.


Then:
=E36+F81

My expected result is 8531.97 but I get 8531.96.

Please HELP!!!!!!
 
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 2007 Polynomial Order Incorrect Darren Charts and Charting in Excel 7 October 23rd 09 04:42 PM
Excel 2007 Trendline Equations Incorrect DanB Charts and Charting in Excel 5 May 30th 08 08:47 PM
SUMPRODUCT gives incorrect total jeannie v Excel Worksheet Functions 10 January 20th 08 02:46 AM
My autosum total is incorrect - what is wrong? Missing the obvious? Excel Discussion (Misc queries) 1 September 3rd 06 04:38 AM
Incorrect total Karen Excel Worksheet Functions 5 November 26th 04 02:41 AM


All times are GMT +1. The time now is 09:56 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"