Syntax: INTERP2D(R1, R2, N)
R1 = a range reference points to x values of the vector
R2 = a range reference points to y values of the vector
N = a numerical value or range for which the interporlation value will be based on. INTERP2D returns interporlated values for a 2-dimensional vector. R1 and R2 have to be same size.
Example:
A | B | |
1 | 1 | 2.5 |
---|---|---|
2 | 3 | 4.5 |
3 | 5 | 8.2 |
4 | 7 | 10.5 |
5 | 9 | 13.4 |
INTERP2D(A1..A5, B1..B5, C1..C2) =
6.35 |
9.35 |
Excel function: N/A