Mathematical Functions

The mathematical functions described in this section perform mathematical operations.

Function	Example	Description	Syntax
ABS	ABS(Profit)	Calculates the absolute value of a numeric expression. expr is any expression that evaluates to a numerical value.	ABS(expr)
ACOS	ACOS(1)	Calculates the arc cosine of a numeric expression. expr is any expression that evaluates to a numerical value.	ACOS(expr)
ASIN	ASIN(1)	Calculates the arc sine of a numeric expression. expr is any expression that evaluates to a numerical value.	ASIN(expr)
ATAN	ATAN(1)	Calculates the arc tangent of a numeric expression. expr is any expression that evaluates to a numerical value.	ATAN(expr)
ATAN2	ATAN2(1, 2)	Calculates the arc tangent of y /x, where y is the first numeric expression and x is the second numeric expression.	ATAN2(expr1, expr2)
CEILING	CEILING(Profit)	Rounds a non-integer numeric expression to the next highest integer. If the numeric expression evaluates to an integer, the CEILING function returns that integer.	CEILING(expr)
COS	COS(1)	Calculates the cosine of a numeric expression. expr is any expression that evaluates to a numerical value.	COS(expr)
COT	COT(1)	Calculates the cotangent of a numeric expression. expr is any expression that evaluates to a numerical value.	COT(expr)
DEGREES	DEGREES(1)	Converts an expression from radians to degrees. expr is any expression that evaluates to a numerical value.	DEGREES(expr)
EXP	EXP(4)	Sends the value to the power specified. Calculates e raised to the n-th power, where e is the base of the natural logarithm.	EXP(expr)
ExtractBit	Int ExtractBit(1, 5)	Retrieves a bit at a particular position in an integer. It returns an integer of either 0 or 1 corresponding to the position of the bit.	ExtractBit([Source Number], [Digits])
FLOOR	FLOOR(Profit)	Rounds a non-integer numeric expression to the next lowest integer. If the numeric expression evaluates to an integer, the FLOOR function returns that integer.	FLOOR(expr)
LOG	LOG(1)	Calculates the natural logarithm of an expression. expr is any expression that evaluates to a numerical value.	LOG(expr)
LOG10	LOG10(1)	Calculates the base 10 logarithm of an expression. expr is any expression that evaluates to a numerical value.	LOG10(expr)
MOD	MOD(10, 3)	Divides the first numeric expression by the second numeric expression and returns the remainder portion of the quotient.	MOD(expr1, expr2)
PI	PI()	Returns the constant value of pi.	PI()
POWER	POWER(Profit, 2)	Takes the first numeric expression and raises it to the power specified in the second numeric expression.	POWER(expr1, expr2)
RADIANS	RADIANS(30)	Converts an expression from degrees to radians. expr is any expression that evaluates to a numerical value.	RADIANS(expr)
RAND	RAND()	Returns a pseudo-random number between 0 and 1.	RAND()
RANDFromSeed	RAND(2)	Returns a pseudo-random number based on a seed value. For a given seed value, the same set of random numbers are generated.	RAND(expr)
ROUND	ROUND(2.166000, 2)	Rounds a numeric expression to n digits of precision. expr is any expression that evaluates to a numerical value. integer is any positive integer that represents the number of digits of precision.	ROUND(expr, integer)
SIGN	SIGN(Profit)	Returns the following: 1 if the numeric expression evaluates to a positive number -1 if the numeric expression evaluates to a negative number 0 if the numeric expression evaluates to zero	SIGN(expr)
SIN	SIN(1)	Calculates the sine of a numeric expression.	SIN(expr)
SQRT	SQRT(7)	Calculates the square root of the numeric expression argument. The numeric expression must evaluate to a nonnegative number.	SQRT(expr)
TAN	TAN(1)	Calculates the tangent of a numeric expression. expr is any expression that evaluates to a numerical value.	TAN(expr)
TRUNCATE	TRUNCATE(45.12345, 2)	Truncates a decimal number to return a specified number of places from the decimal point. expr is any expression that evaluates to a numerical value. integer is any positive integer that represents the number of characters to the right of the decimal place to return.	TRUNCATE(expr, integer)