FORECAST

Calculates a future Y value for a given X value based on existing values.

Syntax

=FORECAST(X, KnownYs, KnownXs)

Arguments

Name	Type	Description
X	Number	Number for which a value should be predicted. Passing non numeric values results in #VALUE! error.
KnownYs	Range	A cell range which defines the dependent y numbers. No number values are ignored.
KnownXs	Range	A cell range which defines the dependent x numbers. No number values are ignored.

Return

Type	Description
Number	A number representing the predicted Y value for given X value.

Examples

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

Formula	Result	Comment
=FORECAST(30,A1:A5,B1:B5)	10.607253
=FORECAST(30,A7:A12,B1:B5)	#NA!	no y values