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.
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.
There is no formula in B29.
