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 |
|---|---|---|
| 10.607253 | |
| #NA! | no y values |