General numeric functions

BitCount() finds how many bits in the binary equivalent of a 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 to the right of the decimal point of x, where x is a real number.

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 modulo function that returns the remainder part of the 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 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 x up to the nearest multiple of step [+ offset]. The default value of offset is 0.

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

Floor() rounds x down to the nearest multiple of step [+ offset]. The default value of offset is 0.

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

Round() returns the result of rounding x up or down to the nearest multiple of step [+ offset]. The default value of offset is 0.

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