This question might be better posed in an OpenOffice group, but Ubuntu
folk are OO users, so maybe you guys have an answer for me :-)
I want to put a formula in a cell that refers to the cell above the one
with the formula in it. For example, I want F2 to contain a formula that
displays the value in F1.
Easy enough of course: =F1
But here's the kicker: If someone adds a new row after F1, which will
make F2 into F3, I want the formula to now refer to F2.
That is, the reference in F2 needs to be relative to F2. It needs to
refer to "the cell above me". When F2 then becomes F3, because someone
has inserted a new row, the formula should still reference "the cell
above me".
I've googled lots, experimented lots, but cannot find this (to me,
obvious) way of referencing a cell.
On Sun, 2011-10-09 at 13:11 +1100, Karl Auer wrote:
> I want to put a formula in a cell that refers to the cell above the one
> with the formula in it. For example, I want F2 to contain a formula that
> displays the value in F1.
>
> Easy enough of course: =F1
>
> But here's the kicker: If someone adds a new row after F1, which will
> make F2 into F3, I want the formula to now refer to F2.
>
> That is, the reference in F2 needs to be relative to F2. It needs to
> refer to "the cell above me". When F2 then becomes F3, because someone
> has inserted a new row, the formula should still reference "the cell
> above me".
=OFFSET(F2,-1,0,1,1)
will do it.
--
JDL
--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
open office cell self-reference?
