Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulas
I have a spreadsheet that is calculating a interest spread. I have numerous
columns where I have applied my formula and I also have summed all the rows and then applied the same formula to the summed rows. If; however, I sum all the formulas to get one overall spread, I get a different result. Shouldn't both results be the same? -- Allan |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulas
Possibly - depends on you formulas - how different is the result - give us
some examples with ColumRow references "Flipper" wrote: I have a spreadsheet that is calculating a interest spread. I have numerous columns where I have applied my formula and I also have summed all the rows and then applied the same formula to the summed rows. If; however, I sum all the formulas to get one overall spread, I get a different result. Shouldn't both results be the same? -- Allan |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulas
Each column D through V has 3 sections section 1 sums 2 rows, divides them by
3 and then adds a 3rd row. Section 2 performs the same function but with diff. data. Section 3 is only used to calculate the spread. The formula at the bottom of each column divides the sum of the 2nd section byt the sum of the 1st section then subtracts section 3's info (which divides 1 row by the next) here is the example: (D19/D14)-(D23/D22) This formula does calculate correctly; however, when I sum each row and then apply the above formula to the totals, I receive a different result than if I simply sum the row with the the column totals. The difference is 0.0717 vs 1.6037. Logically, I shoud get the same result regarless of the methodology. -- Allan "Ron@Buy" wrote: Possibly - depends on you formulas - how different is the result - give us some examples with ColumRow references "Flipper" wrote: I have a spreadsheet that is calculating a interest spread. I have numerous columns where I have applied my formula and I also have summed all the rows and then applied the same formula to the summed rows. If; however, I sum all the formulas to get one overall spread, I get a different result. Shouldn't both results be the same? -- Allan |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formulas
Still difficult to understand your problem. Can you give actual examples of
the data and how it is laid out. But surely if the formula that you detailed gives the correct result, then your alternative calculation must be incorrect. Check your methodology. "Flipper" wrote: Each column D through V has 3 sections section 1 sums 2 rows, divides them by 3 and then adds a 3rd row. Section 2 performs the same function but with diff. data. Section 3 is only used to calculate the spread. The formula at the bottom of each column divides the sum of the 2nd section byt the sum of the 1st section then subtracts section 3's info (which divides 1 row by the next) here is the example: (D19/D14)-(D23/D22) This formula does calculate correctly; however, when I sum each row and then apply the above formula to the totals, I receive a different result than if I simply sum the row with the the column totals. The difference is 0.0717 vs 1.6037. Logically, I shoud get the same result regarless of the methodology. -- Allan "Ron@Buy" wrote: Possibly - depends on you formulas - how different is the result - give us some examples with ColumRow references "Flipper" wrote: I have a spreadsheet that is calculating a interest spread. I have numerous columns where I have applied my formula and I also have summed all the rows and then applied the same formula to the summed rows. If; however, I sum all the formulas to get one overall spread, I get a different result. Shouldn't both results be the same? -- Allan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |