Supported functions
Ixion implements the 57 functions listed below, grouped by category. A function marked volatile gets re-calculated on every calculation, whether or not any cell it references has changed.
The parser also recognizes the names of 265 other functions
that are not implemented yet. A formula using one of them parses, but
yields the #NAME? error when calculated.
Mathematical
Function |
Arguments |
Returns |
Notes |
|---|---|---|---|
|
1 |
||
|
1 |
||
|
2 |
array |
|
|
0 |
||
|
0 |
numeric |
Volatile. |
|
2 |
This function is not fully implemented. |
|
|
1 or more |
Statistical
Function |
Arguments |
Returns |
Notes |
|---|---|---|---|
|
1 or more |
||
|
any number |
numeric |
|
|
any number |
numeric |
|
|
1 |
numeric |
Unlike COUNT() or COUNTA(), this function only takes one argument, and that argument must be a cell or range reference. |
|
1 or more |
||
|
1 or more |
numeric |
|
|
1 or more |
||
|
1 or more |
numeric |
Logical
Function |
Arguments |
Returns |
Notes |
|---|---|---|---|
|
1 or more |
boolean |
|
|
0 |
boolean |
|
|
3 |
||
|
1 |
boolean |
It triggers |
|
1 or more |
boolean |
|
|
0 |
boolean |
Information
Function |
Arguments |
Returns |
Notes |
|---|---|---|---|
|
1 |
boolean |
When a range reference is passed, it returns true only when all of the cells in the specified range are empty. |
|
1 |
boolean |
This is the same as ISERROR except when the error value is |
|
1 |
boolean |
This function does NOT take a range reference. |
|
1 |
boolean |
This function does NOT take a range reference. |
|
1 |
boolean |
|
|
1 |
boolean |
|
|
1 |
boolean |
|
|
1 |
boolean |
This function does NOT take a range reference. Also, the result of this function is the complete opposite of ISTEXT function. |
|
1 |
boolean |
This function does NOT take a range reference. |
|
1 |
boolean |
This function does NOT take a range reference. |
|
1 |
boolean |
This function does NOT take a range reference. |
|
1 |
boolean |
This function does NOT take a range reference. |
|
1 |
numeric |
|
|
0 |
error |
|
|
1 |
numeric |
Text
Function |
Arguments |
Returns |
Notes |
|---|---|---|---|
|
any number |
string |
|
|
2 |
string |
|
|
2 to 3 |
string |
This function performs a case-sensitive search. |
|
1 to 2 |
string |
|
|
1 |
||
|
3 |
string |
|
|
4 |
string |
|
|
2 |
string |
|
|
1 to 2 |
string |
|
|
3 to 4 |
string |
This function is case-sensitive. |
|
1 |
string |
|
|
3 or more |
string |
|
|
1 |
string |
Date and time
Function |
Arguments |
Returns |
Notes |
|---|---|---|---|
|
0 |
numeric |
Volatile. The zero date is 1899-12-30. |
|
0 |
numeric |
Volatile. The zero date is 1899-12-30. |
Spreadsheet
Function |
Arguments |
Returns |
Notes |
|---|---|---|---|
|
up to 1 |
numeric |
|
|
any number |
numeric |
|
|
up to 1 |
numeric |
|
|
any number |
numeric |
|
|
up to 1 |
numeric |
|
|
up to 1 |
numeric |
It triggers an |