General numeric functions

BitCount() returns how many bits in the binary equivalent of a decimal number are set to 1. That is, the function returns the number of set bits in integer_number, where integer_number is interpreted as a signed 32-bit integer.

bitcount(integer_number)

Div() returns the integer part of the arithmetic division of the first argument by the second argument. Both parameters are interpreted as real numbers, that is, they do not have to be integers.

div(integer_number1, integer_number2)

Fabs() returns the absolute value of x. The result is a positive number.

fabs(x)

Fact() returns the factorial of a positive integer x.

fact(x)

Frac() returns the fraction part of x.

frac(x)

Sign() returns 1, 0 or -1 depending on whether x is a positive number, 0, or a negative number.

sign(x)

Combin() returns the number of combinations of q elements that can be picked from a set of p items. As represented by the formula: Combin(p,q) = p! / q!(p-q)! The order in which the items are selected is insignificant.

combin(p, q)

Permut() returns the number of permutations of q elements that can be selected from a set of p items. As represented by the formula: Permut(p,q) = (p)! / (p - q)! The order in which the items are selected is significant.

permut(p, q)

fmod() is a generalized modulo function that returns the remainder part of the integer division of the first argument (the dividend) by the second argument (the divisor). The result is a real number. Both arguments are interpreted as real numbers, that is, they do not have to be integers.

fmod(a, b)

Mod() is a mathematical modulo function that returns the non-negative remainder of an integer division. The first argument is the dividend, the second argument is the divisor, Both arguments must be integer values.

mod(integer_number1, integer_number2)

Even() returns True (-1), if integer_number is an even integer or zero. It returns False (0), if integer_number is an odd integer, and NULL if integer_number is not an integer.

even(integer_number)

Odd() returns True (-1), if integer_number is an odd integer or zero. It returns False (0), if integer_number is an even integer, and NULL if integer_number is not an integer.

odd(integer_number)

Ceil() rounds up a number to the nearest multiple of the step shifted by the offset number.

ceil(x[, step[, offset]])

Floor() rounds down a number to the nearest multiple of the step shifted by the offset number.

floor(x[, step[, offset]])

Round() returns the result of rounding a number up or down to the nearest multiple of step shifted by the offset number.

round( x [ , step [ , offset ]])