FORECAST.ETS
Forecasts a value using exponential smoothing.
- Excel: Differs in detail
- Google Sheets: No equivalent
- Returns: Number
Examples
=FORECAST.ETS(11, A1:A5, G1:G5, 1) | A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | 10 | 1 | |||||
| 2 | 20 | 3 | |||||
| 3 | 30 | 5 | |||||
| 4 | 40 | 7 | |||||
| 5 | 50 | 9 |
Result 59.9029406910596
Syntax
FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation])target_date- number required
values- range required
timeline- range required
seasonality- number optional
data_completion- number optional
aggregation- number optional
Errors
#VALUE!=FORECAST.ETS(DATE(2026,1,15), A1:A3, 2)