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

FunctionSyntaxDescriptionExample
ABSABS(number)Returns the absolute value of a number.ABS(-5) = 5
AVERAGEAVERAGE(number1, number2, ...)Returns the average (arithmetic mean) of a group of numbers.AVG(4, 10) = 7
ROUNDROUND(number, [decimals])Rounds a value to the nearest integer or specified number of decimal places.ROUND(3.67) = 4
LNLN(number)Returns the natural logarithm of a number.LN(E * E) = 2
LOGLOG(number, base)Returns the logarithm of a number to the base you specify.LOG(5, 625) = 0.25
LOG10LOG10(number)Returns the base-10 logarithm of a number.LOG10(1000) = 3
MAXMAX(number1, number2, ...)Returns the number representing the largest value among a group of numbers.MAX(4, 2, 8, 1, 5) = 8
MINMIN(number1, number2, ...)Returns the number representing the smallest value among a group of numbersMIN(4, 2, 8, 1, 5) = 1
POWERPOWER(number, power)Returns the result of a number raised to a power.POWER(2.5, 3) = 15.625
EXPEXP(number)Returns E (the base of natural logarithms) raised to the specified power.EXP(2) = 7.38905609893065
SQRTSQRT(number)Returns the square root of a number.SQRT(64) = 8
SINSIN(angle)Express angle in radians. Returns the sine of an angle.SIN(PI / 6) = 0.5
COSCOS(angle)Express angle in radians. Returns the cosine of an angle.COS(PI / 3) = 0.5
TANTAN(angle)Express angle in radians. Returns the tangent of an angle.TAN(PI / 4) = 1
COTCOT(angle)Express angle in radians. Returns the cotangent of an angle.COT(PI / 2) = 0
ACOSACOS(number)Returns the arc-cosine of a number in radians.ACOS(0.5) = PI / 3
ACOTACOT(number)Returns the arc-cotangent of a number in radians.ACOT(1) = PI / 4
ASINASIN(number)Returns the arcsine of a number in radians.ASIN(0.5) = PI / 6
ATANATAN(number)Returns the arctangent of a number in radians.ATAN(1) = PI / 4