Hello, I've been trying to create a sheet with a kind of recursive arguement
the idea is that cell b15 uses the value from b14 uses the value from b13
uses the value from b12... up through b2. While I could enter each one by
hand, is there a way to dynamically define the arguement? For example, a
java-ish version might be (This-1) with this referring to the current cell.
That way if I add more to the column, I won't have to update the formula each
time. If there's another way to do this as well, any advice is welcome :)

Thank you in advance.

In B3, enter =B2+1
Select B3 and drag the little black box in the lower right corner down to
B15.

Is that what you need?



"numberoverzero" wrote:

Hello, I've been trying to create a sheet with a kind of recursive arguement
the idea is that cell b15 uses the value from b14 uses the value from b13
uses the value from b12... up through b2. While I could enter each one by
hand, is there a way to dynamically define the arguement? For example, a
java-ish version might be (This-1) with this referring to the current cell.
That way if I add more to the column, I won't have to update the formula each
time. If there's another way to do this as well, any advice is welcome :)

Thank you in advance.