Math Functions Overview

Use Math functions to manipulate the numeric values of your data. Math functions can use the following data types: Decimal, Float, and Integer.

Function	Description
Abs(number)	Returns the absolute value of a specified number.
Acos(number)	Returns the angle whose cosine is the specified number.
Asin(number)	Returns the angle whose sine is the specified number.
Atan(number)	Returns the angle whose tangent is the specified number.
Atan2(y, x)	Returns the angle whose tangent is the quotient of two specified numbers.
BigMul(a, b)	Produces the full product of two 32-bit numbers.
Ceiling(number)	Returns the smallest integral value that is greater than or equal to the specified decimal or double-precision floating-point number.
Cos(angle)	Returns the cosine of the specified angle.
Cosh(angle)	Returns the hyperbolic cosine of the specified angle.
Exp(power)	Returns the cosine of the specified angle.
Floor(number)	Returns the largest integral value that is less than or equal to the specified decimal or double-precision floating-point number.
Log(number)	Returns the natural (base e) logarithm of a specified number.
Log(number, newBase)	Returns the logarithm of a specified number in a specified base.
Log10(number)	Returns the base 10 logarithm of a specified number.
Pow(number, power)	Returns a specified number raised to the specified power.
Random()	Returns a 32-bit signed integer greater than or equal to zero .
Round(number)	Rounds a decimal or a double-precision floating-point number to the nearest integral value. Uses ToEven (banker's) midpoint rounding: when a value is exactly halfway between two integers, it rounds to the nearest even number (e.g., 2.5 → 2, 3.5 → 4).
Round(number, digits)	Rounds a decimal or a double-precision floating-point number to the specified number of fractional digits. Uses ToEven (banker's) midpoint rounding: when a value is exactly halfway, it rounds to the nearest even digit (e.g., 2.25 rounded to 1 digit → 2.2, 2.35 → 2.4).
Sign(number)	Returns a value (-1, 0, 1) indicating the sign of a number.
Sin(angle)	Returns the sine of the specified angle.
Sqrt(number)	Returns the hyperbolic sine of the specified angle.
Tan(angle)	Returns the tangent of the specified angle.
Tanh(angle)	Returns the hyperbolic tangent of the specified angle.
Truncate(number)	Calculates the integral part of a specified number