Intermediate value of a set of array.
HARSHAWARDHAN. S .SHASTRI wrote:
Actually i have raised this query about 2 years back in same forum but
still i have not got satisfactory solution.
What i looking for is ,
I am having a data for cam profile. data is in angle and radius which may
looks like
angle radius
1 10
2 10.3
3 10.6
4 10.85
. .
100 32
359 10.3
What i need is intermediate value of radius, say at angle 3.7 degrees.
I am having total 360 readings at interval of 1 deg.
Harshawardhan Shastri
================================================== ======
Maybe GROWTH()?
If I put your first four sets of data in A1:B4 and the following in C1 I get a
result of 10.78063022:
=GROWTH(B1:B4,A1:A4,3.7)
Is that what you are expecting?
|