TREND
Values along a linear trend.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Array
Examples
=TREND(A1:A10) | A | |
|---|---|
| 1 | 10 |
| 2 | 20 |
| 3 | 30 |
| 4 | 40 |
| 5 | 50 |
Result 30.000000000000004
Syntax
TREND(known_ys, [known_xs], [new_xs], [const])known_ys- range required
known_xs- range optional
new_xs- range optional
const- boolean optional
Errors
#VALUE!=TREND(2)