next up previous contents index
Next: FORMAT Up: A Function Reference Previous: FLOOR

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


next up previous contents index
Next: FORMAT Up: A Function Reference Previous: FLOOR

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999