M
mehta.nitin
I have a tool for integrating and differentiating functions using
Excel, see
http://www.engineersexcel.com/Tools/Function Calculus/Description.htm
I have 2 questions:
1. Can a named formula be used for integration ? That is, if a named
range, say X(n) has n numbers in it, can there be a named formula Y(n)
that works as follows:
Y(1) = X(1)
Y(n) = Y(n-1) + X(n) for all n > 1 ?
2. Is there a way a data table can be stored as a named range ?
(If the above are possible, then it will be possible to rewrite the
tool without any calculations on the spreadsheet itself.)
Any comments would be appreciated. Thank you.
Nitin Mehta
Excel, see
http://www.engineersexcel.com/Tools/Function Calculus/Description.htm
I have 2 questions:
1. Can a named formula be used for integration ? That is, if a named
range, say X(n) has n numbers in it, can there be a named formula Y(n)
that works as follows:
Y(1) = X(1)
Y(n) = Y(n-1) + X(n) for all n > 1 ?
2. Is there a way a data table can be stored as a named range ?
(If the above are possible, then it will be possible to rewrite the
tool without any calculations on the spreadsheet itself.)
Any comments would be appreciated. Thank you.
Nitin Mehta