Function Arguments

The list of possible function arguments

Any

Any means that the parameter can take value of any type.

Examples

Function SET_CELL_VALUE() takes any value as a second argument.

=SET_CELL_VALUE(A1, 123)
Copy to clipboard
=SET_CELL_VALUE(A1, "string")
Copy to clipboard
=SET_CELL_VALUE(A1, {"frame", "literal"})
Copy to clipboard

Formula Expression

Formula Expression argument means that a function takes a formula as an input parameter, which may be or may not be evaluated, depending on some conditions.

Example

A good example of such "short-circuit" behavior is IF() function. In the following example, the 2nd and the 3rd parameters are of Formula Exression type. Only one of them will be actually evaluated, depending on A1 value.

=IF(A1 = TRUE, SUM(A2:A10), AVG(B2:B10))
Copy to clipboard

Another example uses named columns. To refer to a column, type its name prepended with @.

Function SET_FRAME_CELL() takes a formula expression as the third argument. For the below example assume that cell A1 contains a data frame with at least two columns: id and price.

=SET_FRAME_CELL(A1, "price", @id = 42, 149.99)
Copy to clipboard

How to read this: "In the data frame located at A1 cell, set price column value to 149.99 where id column has value 42"

Range

The Range type is a reference to a Spreadsheet cell, or to a range of cells. MINTDATAâ„¢ works with A1 notation.

Examples

A single-cell range:

=A1
Copy to clipboard

A range of 5 columns and 5 rows:

=A1:E5
Copy to clipboard

A fixed range reference:

=$K$10
Copy to clipboard

Range List

The Range List type is a special type for functions, which can take more than one Range as an argument.

Example

Executing multiple ranges with DO() function:

=DO(B10, A11:E11, $K$31)
Copy to clipboard
Contents