Formula Engine Reference Guide
 

 

Back to Class Index

 

INTERP2D(R1, R2, N)

Description
INTERP2D returns interpolated values for a 2-dimensional vector. R1 and R2 have to be same size.
 
Parameters
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 on which the interpolation value will be based.
 
Example
0   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
where C1..C2 = 4, 6