Reference
No results for 'undefined'
    Powered by Algolia

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