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 the n's in column A, the f(n) data in column B and I'm putting the approximation in column C.
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? (I hope this is clear.)
-Dan
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.
If you have Excel 365 it is possible to use Lambda functions to capture the mathematical relationships without needing to reference the grid explicitly.
A function of n = f(n) where n = SEQUENCE(101,1,0,1) A specific value =F(10) Example definition f = LAMBDA(r, EXP(-r/10)*SIN(r/10))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
