/
Functions List
Functions List
- Kimberly Onnen
Owned by Kimberly Onnen
Dec 01, 2023
Loading data...
On the Formula and Template tabs, functions run vertically down the formula section.
Functions are represented algebraically through formulas or equations. These equations describe the relationship between an independent and a dependent variable. You do not have to use functions to create your formula.
| Function | Description |
|---|---|
| (n) | Converts a value to a number. For example, True = 0, False = 1. |
| Ceiling (n) | Rounds a number to the nearest integer. |
| Floor (n) | Rounds a number down, toward zero. |
| Round (n) | Rounds a number to a specified number of digits. |
| ABS (n) | Returns the absolute value of a number. |
| DayOfWeek | Returns the integer number of days as a timespan. (Sunday = 1, S) |
| HourOfDay | Returns the integer hour number of the day (0-23). |
| TimeOfDay | Returns the actual current date as a 'DAY MM DD HH:MM:SS.US YYYY TZ' format. |
| Max | Returns the maximum value in a list of arguments. |
| Min | Returns the minimum value in a list of arguments |
| Sqrt (n) | Returns a positive square root. |