TREND(NX, KX, KY)

Description
Fits a straight line to KX (known x's) and KY (known y's) using least square method, and then returns the y values along the line for NX (new x's).

Parameters
NX
range for new x values for which TREND will return corresponding y values

KX
known x values

KY
known y values

Example
A
8
9
10
B               C
X values     Y values
1               242
2               256
3               263
4               274
5               279
6               285
7               290
TREND(A1..A2, B11..B17, C11..C17) =
301
308.7857
316.5714