N
numberoverzero
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.
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.