I have some rate-of-change triangles I need to change. These show the
annual rate of change for different numbers of years and look like this:
2010X X X X X
2011X X X X
2012X X X
2013X X
2014X
Basically, I want to
On 04/01/15 15:39, Robert Peirce wrote:
I have some rate-of-change triangles I need to change. These show the
annual rate of change for different numbers of years and look like this:
2010XXXXX
2011XXXX
2012XXX
2013XX
2014X
You might have the answer in your own question, even I am not quite
ready in my thinking about this.
If you move the formula (e.g. via the sequence ctrl+X and ctrl+V at the
new position, well you can do it via the edit menu instead) the
references do not change, the formula still points at