next up previous contents index
Next: FORMAT Up: A. Function Reference Previous: FLOOR, XLFLOOR   Contents   Index


FORECAST

Syntax: FORECAST(X', X, Y)

X'= New x value
X = Old x value
Y = Old y value

FORECAST returns Y', the predicted value for y for X', given original x and y values X and Y.

Example:

  A B
1 20 6
2 28 7
3 31 9
4 38 15
5 40 21
     

FORECAST(30, A1..A5, B1..B5) = 10.60725

Excel function: N/A


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