next up previous contents index
Next: INTERP3D Up: A. Function Reference Previous: INT, XLINT   Contents   Index


INTERP2D

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
, where C1..C2 = 4, 6

Excel function: N/A


next up previous contents index
Next: INTERP3D Up: A. Function Reference Previous: INT, XLINT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003