Forum Discussion
Solved
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 eac...
There is no formula in B29.
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.