View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default 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?