https://bugs.documentfoundation.org/show_bug.cgi?id=154813
--- Comment #5 from Rafael Lima <rafael.palma.l...@gmail.com> --- The problem here is simple. You're always dividing H1 by the values in column C, but the value of H1 is fixed. When you drag down the formula, H1 gets updated downwards (H2, H3, H4...) as well as column C (C3, C4, C5...). But in the case of column H, since you want to keep it fixed in H1, you need to lock it. For that, replace H1 in the formula by $H$1, which locks the column/row. Closing this as NAB. -- You are receiving this mail because: You are the assignee for the bug.
