The following is a list of commonly supported functions:
| Function Name | Description | Example |
|---|---|---|
| SUM | Summation function | Sum the values of cells A1 to C1: SUM(A1:C1) |
| IF | Conditional function | IF(10>5,"Yes","No") |
| CONCATENATE | Concatenation function | CONCATENATE(text1,text2,[text3],...) |
| NOW | System current date and time function | For more information, see Date and Time Formatting |
| TRUNC | Truncation function | TRUNC(3.141593) // Returns 3 |