Formula Operators and Functions

Formula operators and functions are used in entering the formula items that are used to build the formula.The following operators and functions are available.

Operators

• Plus +, Arithmetic expression
• Minus -, Arithmetic expression
• Multiplication *, Arithmetic expression
• Division /, Arithmetic expression
• Comma , , Separator in a Function
• Open Parenthesis (, Arithmetic and Function
• Close Parenthesis ), Arithmetic and Function

Functions

• ABS (n): Absolute value of n
• CEIL (n): Smallest integer greater if equal to n
• COS (n): Cosine of n in radians
• COSH (n): Hyperbolic cosine of n
• DECODE (expr, search1,return1, [search2,return2,]…[default]): If expr equals any search, return the following return; if not returns default
• EXP (n): e raised to the n:th power
• FLOOR (n): Largest integer equal to or less than n
• LN (n): Natural logarithm of n, where n > 0
• LOG (m,n): Logarithm, base m, of n
• MOD (m,n): Remainder of m divided by n
• NVL (expr1,expr2): expr2, if expr1 is null, otherwise expr1
• POWER (m,n): m raised to the n:th power
• ROUND (n[,m]): n rounded to m decimals; m defaulted to 0 SIGN (n): If n <0, -1; If n =0, 0;If n >0, 1
• SIN (n): Sine of n in radians
• SINH (n): Hyperbolic sine of n
• SQRT (n): Square root of n; if n < 0,NULL
• TAN (n): Tangent of n in radians
• TANH (n): Hyperbolic tangent of
• TRUNC (n[,m]): n truncated to m decimals; m defaults to 0