ABS()

https://api.typedream.com/v0/app/collection_content/01197c9b-c2ce-4e76-96a6-8091ea6b0dca_97a8d4ea-b7ef-47d7-83fd-da22764e033a_collection_rich_content.json

Constrains an array result to a specified size. 

ARRAY_CONSTRAIN()

https://api.typedream.com/v0/app/collection_content/9e8a5b41-471b-43de-8c39-fc4f44fd12e5_97a8d4ea-b7ef-47d7-83fd-da22764e033a_collection_rich_content.json

Groups an array by columns by application of a LAMBDA function to each column. 

BYCOL()

Groups an array by columns by application of a LAM...

Groups an array by rows by application of a LAMBDA function to each row. 

BYROW()

Groups an array by rows by application of a LAMBDA...

Flattens all the values from one or more ranges into a single column. 

FLATTEN()

Flattens all the values from one or more ranges in...

Calculates the frequency distribution of a one-column array into specified classes. 

FREQUENCY()

Calculates the frequency distribution of a one-col...

Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values. 

GROWTH()

Given partial data about an exponential growth tre...

Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method. 

LINEST()

Given partial data about a linear trend, calculate...

Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve. 

LOGEST()

Given partial data about an exponential growth cur...

Returns an array of specified dimensions with values calculated by application of a LAMBDA function. 

MAKEARRAY()

Returns an array of specified dimensions with valu...

Maps each value in the given arrays to a new value by application of a LAMBDA function to each value. 

MAP()

Maps each value in the given arrays to a new value...

Returns the matrix determinant of a square matrix specified as an array or range. 

MDETERM()

Returns the matrix determinant of a square matrix ...

Returns the multiplicative inverse of a square matrix specified as an array or range. 

MINVERSE()

Returns the multiplicative inverse of a square mat...

Calculates the matrix product of two matrices specified as arrays or ranges. 

MMULT()

Calculates the matrix product of two matrices spec...

Reduces an array to an accumulated result by application of a LAMBDA function to each value. 

REDUCE()

Reduces an array to an accumulated result by appli...

Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step. 

SCAN()

Scans an array and produces intermediate values by...

Returns the sum of a series of numbers and/or cells.

SUM()

https://api.typedream.com/v0/app/collection_content/f2f2e666-8f96-4eb6-95e2-238e5984bf86_97a8d4ea-b7ef-47d7-83fd-da22764e033a_collection_rich_content.json

Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.

VLOOKUP()

Vertical lookup. Searches down the first column of…

https://api.typedream.com/v0/app/collection_content/0b7516a6-0207-48fc-992e-7f6e40230ea7_4dc0893a-7a5d-4c81-b8a0-bd70d1451607_collection_rich_content.json

Formulas