Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Polynomial Order Incorrect | Charts and Charting in Excel | |||
Excel 2007 Trendline Equations Incorrect | Charts and Charting in Excel | |||
SUMPRODUCT gives incorrect total | Excel Worksheet Functions | |||
My autosum total is incorrect - what is wrong? | Excel Discussion (Misc queries) | |||
Incorrect total | Excel Worksheet Functions |