Skip to main content
Version: Streamsheets 3.0

FORECAST

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

Syntax

=FORECAST(X, KnownYs, KnownXs)

Arguments

NameTypeDescription
XNumberNumber for which a value should be predicted. Passing non numeric values results in #VALUE! error.
KnownYsRangeA cell range which defines the dependent y numbers. No number values are ignored.
KnownXsRangeA cell range which defines the dependent x numbers. No number values are ignored.

Return

TypeDescription
NumberA number representing the predicted Y value for given X value.

Examples

AB
1620
2728
3931
41538
52140
FormulaResultComment
=FORECAST(30,A1:A5,B1:B5)
10.607253
=FORECAST(30,A7:A12,B1:B5)
#NA!no y values