Math Functions in Expressions
Math functions are used for mathematical calculations in an expression.
Math
The following information describes the functions available for building expressions.
| Function | Syntax | Description | Example |
|---|---|---|---|
| ABS | ABS(number) | Returns the absolute value of a number. | ABS(-5) = 5 |
| AVERAGE | AVERAGE(number1, number2, ...) | Returns the average (arithmetic mean) of a group of numbers. | AVG(4, 10) = 7 |
| ROUND | ROUND(number, [decimals]) | Rounds a value to the nearest integer or specified number of decimal places. | ROUND(3.67) = 4 |
| LN | LN(number) | Returns the natural logarithm of a number. | LN(E * E) = 2 |
| LOG | LOG(number, base) | Returns the logarithm of a number to the base you specify. | LOG(5, 625) = 0.25 |
| LOG10 | LOG10(number) | Returns the base-10 logarithm of a number. | LOG10(1000) = 3 |
| MAX | MAX(number1, number2, ...) | Returns the number representing the largest value among a group of numbers. | MAX(4, 2, 8, 1, 5) = 8 |
| MIN | MIN(number1, number2, ...) | Returns the number representing the smallest value among a group of numbers | MIN(4, 2, 8, 1, 5) = 1 |
| POWER | POWER(number, power) | Returns the result of a number raised to a power. | POWER(2.5, 3) = 15.625 |
| EXP | EXP(number) | Returns E (the base of natural logarithms) raised to the specified power. | EXP(2) = 7.38905609893065 |
| SQRT | SQRT(number) | Returns the square root of a number. | SQRT(64) = 8 |
| SIN | SIN(angle) | Express angle in radians. Returns the sine of an angle. | SIN(PI / 6) = 0.5 |
| COS | COS(angle) | Express angle in radians. Returns the cosine of an angle. | COS(PI / 3) = 0.5 |
| TAN | TAN(angle) | Express angle in radians. Returns the tangent of an angle. | TAN(PI / 4) = 1 |
| COT | COT(angle) | Express angle in radians. Returns the cotangent of an angle. | COT(PI / 2) = 0 |
| ACOS | ACOS(number) | Returns the arc-cosine of a number in radians. | ACOS(0.5) = PI / 3 |
| ACOT | ACOT(number) | Returns the arc-cotangent of a number in radians. | ACOT(1) = PI / 4 |
| ASIN | ASIN(number) | Returns the arcsine of a number in radians. | ASIN(0.5) = PI / 6 |
| ATAN | ATAN(number) | Returns the arctangent of a number in radians. | ATAN(1) = PI / 4 |