Functions List

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.