Gents and Ladies,
I'm a little bit embarrassed to ask such a seemingly easy question, but I have somewhat of an issue that is really getting under my skin here.
In one cell I have a straightforward and simple formula (For example: =(F2+G2+H2)/2))
My problem is that when i insert a a column the formula changes to =(G2+H2+I2)/2 regardless of the cell reference being absolute or not. I would like the formula to always refer to the same cell no matter if I insert a column or not. (In other words, the formula to remain unchanged)
I'm absolutely stymied by this.