### LINEST Function Excel

This Excel Tutorial demonstrates how to use the Excel LINEST Function in Excel to calculate statistics about a trendline, with formula examples.

## LINEST Function Description:

The LINEST Function Calculates statistics about a trendline fitted to known data points using the least squares method.

## Formula Examples: Example Formula Result
1 {=LINEST(\$B\$5:\$B\$10,\$C\$5:\$C\$10)}

## Syntax and Arguments:

The Syntax for the LINEST Formula is:

### Function Arguments ( Inputs ):

known_y’s – An array of known Y values.

known_x’s – An array of known X values.

const – OPTIONAL. Logical value indicating whether to calculate B (the intercept in y = mx + b) using the least squares method (TRUE Or Ommitted) or to manually set B = 0 (FALSE).

stats – OPTIONAL. Return additional statistics (TRUE) or only return m (slope) and b (intercept) (FALSE or Omitted)

## LINEST Examples in VBA

You can also use the LINEST function in VBA. Type:
`application.worksheetfunction.linest(known_ys,known_xs,const,stats)`

Executing the following VBA statement

will produce the following results For the function arguments (known_y’s, etc.), you can either enter them directly into the function, or define variables to use instead.

`=AND(`  