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. |