Syntax: INTERP3D(R, X, Y)
R = a range reference points to x, y and z values of the
vector
X = x values on which the interpolation values are based
Y = y values on which the interpolation values are based
INTERP3D returns interporlated value for a 3 dimensional vector. X and Y have to be same size.
Example:
A | B | C | D | E | F | G | |
1 | 12.5 | 14.5 | 15.5 | 18.2 | 19.5 | 22.5 | |
---|---|---|---|---|---|---|---|
2 | 11.5 | 1 | 2 | 3 | 4 | 5 | 6 |
3 | 13.5 | 7 | 8 | 9 | 10 | 11 | 12 |
4 | 16.5 | 13 | 14 | 15 | 16 | 17 | 18 |
5 | 17.5 | 19 | 20 | 21 | 22 | 23 | 24 |
6 | 18.5 | 25 | 26 | 27 | 28 | 29 | 30 |
7 | 20.5 | 31 | 32 | 33 | 34 | 35 | 36 |
INTERP3D(A1..G6, A11..A12, B11..B12) =
3.25 |
12.5556 |
Excel function: N/A