Forum Discussion
Mystified by this simple table
So...
I have a column of base figures (B) which I need to add up to 1.00 and currently add up to 0.97.
In the next column, I calculate the multiplier (=1/B32) required achieve that and multiply each row in column C by that value. As expected every value in column C is slightly higher than the corresponding value in column B.
So why is the total of column C LOWER than the total of column B!!
I am sure I am going to be very embarrassed when this is explained, I must be missing something, but for the life of me I can't see it!
There is no formula in B29.
6 Replies
Well I knew I was going to be embarrassed, thanks for your time. There is a formula in B29 in the original table I extract this from, but it was reference more cells than I had realised. Poor concentration day...
thanks again.
There are a lot of mysteries here.
What is in B32?
What formulas are in the cells?
If B29 is really SUM(B7:B30) - as the text suggests - then it results in a circular reference and it omits the values from rows 4 to 6.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
I tried to copy paste in my original post, but got errors about invalid html... here it is attached. thanks
If you enter the formula =SUM(B4:B27) in B29, the result is 0.93.
Because of that, C2 will be 1.075... andC29 will be 1.
