INTERCEPT (PQL - xl)

This function returns the coordinates of a point at which a line intersects the y-axis, by using existing x values and y values

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

INTERCEPT(known ys, known xs)

Function Arguments

Name

Description

Type

Optional

known ys

An array of known dependent values (y’s)

StringOrNumber

known xs

An array of known independent values (x’s)

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'INTERCEPT' function - using the same inputs, logic and outputs.