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.
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))