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)

=SET_CELL_VALUE(A1, "string")

=SET_CELL_VALUE(A1, {"frame", "literal"})

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))

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)

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

A range of 5 columns and 5 rows:

=A1:E5

A fixed range reference:

=$K$10

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)