# TREND

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns values along a linear trend. This function fits a straight line to the arrays known x and y values. Trend returns the y values along that line for the array of specified new x values.

## Syntax

TREND(*y*,*x*,*newx*,*constant*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *y* | Set of y values that are known in the relationship y=mx+b |
| x | (Optional) X is an optional set of x values that may be known in the relationship y=mx+b |
| *newx* | New x values for which this functions returns the corresponding y values |
| *constant* | Logical value that specifies whether to force the constant b to equal 0 |

## Remarks

If constant is true or omitted then b is calculated normally. If constant is false then b is equal to 0 and the m values are adjusted so that y=mx.
If x is omitted then x defaults to the array {1,2,3...}, that has the same dimensions as y.
If newx is omitted then it defaults to x.
Use the [INDEX](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionINDEX) function to get individual elements from the returned array.

## Data Types

Accepts an array. Returns an array.

## Examples

`TREND(A2:A7,C2:C7,A9:A10)`

## Version Available

This function is available in product version 2.0 or later.

## See Also

[AVEDEV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionAVEDEV) \| [AVERAGEA](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionAVERAGEA) \| [FREQUENCY](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionFREQUENCY) \| [DEVSQ](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDEVSQ) \| [GROWTH](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionGROWTH) \| [INDEX](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionINDEX) \| [MEDIAN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionMEDIAN) \| [VAR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionVAR) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)