Forum Discussion
Solved
I would like to see if there is a way to mathematically manipulate cell indices?
I need the Enterprise computer. Just as a check that might save me a bit of trouble. I am doing a discrete fit to a data set of the form a(n) f(n) + b(n) f(n + 1) + c(n) f(n + 2) +.... I have t...
topsquarksgmailcom wrote: ``Is there way to do something like: = A1^2*B(1 + 0) + A1*B(1 + 1) + ... where the B(1 + 0) is the cell B1 and B(1 + 1) is the cell B2?``
INDEX(B:B, 1+0) for B(1+0)
INDEX(B:B, 1+1) for B(1+1)
I'm sure you can see how to generalize that for n, n+1, etc.
topsquarksgmailcom wrote: ``Is there way to do something like: = A1^2*B(1 + 0) + A1*B(1 + 1) + ... where the B(1 + 0) is the cell B1 and B(1 + 1) is the cell B2?``
INDEX(B:B, 1+0) for B(1+0)
INDEX(B:B, 1+1) for B(1+1)
I'm sure you can see how to generalize that for n, n+1, etc.
- Aside from the slight problem that I've been working with Mathematica too much and tried to use [ instead of ( it worked fine! Thanks! You've saved me a lot of effort!
-Dan
