Ask Your Question
0

Calc: reference same cell number after insert row?

asked 2016-12-31 02:17:26 +0200

Nikolay Georgiev gravatar image

In an emtpy sheet, If A3=10, what value should A1 have, so that both of the following statements are true:

  1. A1 displays the value 10
  2. After inserting a new row between A1 and A3, A4 displays 10 and A1 displays the value of A3, which is currently empty.

What I already tested:

  • If A1=A3 or A1=A$3, statement 1 is correct, but statement 2 is incorrect, because after inserting a new row the value of A1 changes to A4 or A$4 respectively, and does not remain A3 or A$3 as desired.

Thank you!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-12-31 07:00:21 +0200

pierre-yves samyn gravatar image

Hi

=INDIRECT("A3")

Regards

edit flag offensive delete link more

Comments

thank you! It works and it is exactly what I was looking for!

Nikolay Georgiev gravatar imageNikolay Georgiev ( 2016-12-31 15:46:36 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-12-31 02:17:26 +0200

Seen: 42 times

Last updated: Dec 31 '16