next up previous contents index
Next: INTRATE Up: A. Function Reference Previous: INTERP2D   Contents   Index


INTERP3D

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
, where A11..A12 = 12, 15, and B11..B12 = 14, 17

Excel function: N/A


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