well actually it won't be a problem in my current calculations. It was just
an observation during testing.

I had another advice to create the following Visual Basic code:

Function RelativeCellValue(Optional column, Optional row)
Application.Volatile
answer = Application.Caller.Offset(row, column)
RelativeCellValue = answer
End Function

It provides a complete relative referencing.

"HPH" wrote:

Everything was fine, until i inserted a column...
Your clever trick unfortunately can't cope with column inserts.

So I am open to new suggestions.

"Teethless mama" wrote:

=INDIRECT("B"&ROW()-1)+INDIRECT("A"&ROW())


"HPH" wrote:

How do I insert a new line in a excel spreadsheet without destroying the
consistency of the formulas?

Cut down to a minimum, the following is what I want.

Starting point:
B2=B1+A2
B3=B2+A3

Desired result after inserting a new line BETWEEN line 2 and line 3:
B2=B1+A2
B3=B2+A3
B4=B3+A4

I have been using SuperCalc for many years now, where this is a very simple
command. But I have newer been able to make the shift to excel. Just because
I could not figure out how to make this simple insert.
I have been trying at least four different types of relative referencing,
but they are all producing the wrong result:
B2=B1+A2
B3=<empty
B4=B2+A4