# Documentation/Calc Functions/TREND

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

TREND

## Category:

Array

## Summary:

Returns values along a linear trend.

## Syntax:

TREND(**DataY**; **DataX**; **NewDataX**; **LinearType**)

## Returns:

## Arguments:

**DataY** represents the Y Data array.

**DataX** (optional) represents the X Data array.

**NewDataX** (optional) represents the array of the X data, which are used for recalculating values.

**LinearType** (optional). If **LinearType** = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is **LinearType** <> 0.

In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.

More explanations on top of this page.

## Additional details:

## Examples:

Select a spreadsheet range in which the trend data will appear. Select the function. Enter the output data or select it with the mouse. Mark the **Array** field, click **OK**. The trend data calculated from the output data is displayed.