Non-Mathematical Functions

Table 4.3. 

Name Description
cell(a,b) In the contex of a matrix, returns the value at row a and column b. In the context of a table, returns the value at column a and row b (remember that tables use column logic). Everywhere else, this function is undefined. In the case of tables, the column is specified as a path string; see the documentation of column() for supported path formats.
cell_(column, row) In the context of a table, return the value of a cell specified using 1-based indices. Wherever possible, you should use cell() instead, because inserting/removing/moving columns will break formulas using cell_().
col(c) DEPRECATED; use column() or cell() instead. Note that the user interface still uses col() until a proper language-specific mechanism is implemented.
column("path") In a column formula, returns the value in the given column and current row (i). The column path can either be the name of column in the current table, more generally a relative path to a column in another table (e.g. "../otherTable/col") or an absolute path (i.e., relative to the project root; e.g. "/folder/otherTable/col"). Searching for a table anywhere in the project using "otherTable/col" (without leading slash) is supported for backwards-compatibility reasons, but is strongly discouraged - a future release will drop the requirement of project-wide unique table names, at which point this usage will cease to be well-defined.
column_(index) In a column formula, returns the value in the column given by 1-based index and current row (i). You should use column() wherever possible, because inserting/ removing/moving columns will break formulas using column_().
if(e1,e2,e3) if e1 is true, e2 is executed else e3 is executed.
tablecol(t,c) DEPRECATED; use column() instead.