FORECAST

Predicts a value along a linear trend.

Excel: Verified match
Google Sheets: Verified match
Returns: Number

Examples

=FORECAST(4, B1:B3, A1:A3)

	A	B
1	10	2
2	20	4
3	30	6

Result 0.8

Syntax

FORECAST(x, known_ys, known_xs)

x: number required
known_ys: range required
known_xs: range required

Errors

#DIV/0!: =FORECAST(5, A1:A3, B1:B3)
#ERROR!: =FORECAST(1, 2)

AVEDEVAverage of absolute deviations from the mean. AVERAGE.WEIGHTEDAverage of values weighted by a second range. AVERAGEAAverages values including text and logicals. AVERAGEIFAverages cells that match a condition. AVERAGEIFSAverages cells matching multiple conditions. BETA.DISTBeta distribution.