| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to interpolate in an array forX and Y values to get Z?
I am interpolating in an array
for ex, 5 6 8 9 2 22.5 23.4 25.6 28 3 20.2 21.5 22.6 23 4 19 20 21.2 22 5 18 19.2 20 20.5 The First Row is (Xvalues) and the first coumn (Yvalues) For ex, For X=5.5 and Y=2.5, the interpolated value will be 21.90. How can i write a formula for this? i would appreciate your help. Thanks so much in advance |
Threaded Mode
