Formulas

  • Thread starter Thread starter Flipper
  • Start date Start date
F

Flipper

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?
 
Possibly - depends on you formulas - how different is the result - give us
some examples with ColumRow references
 
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.
 
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.
 
Back
Top