Mathematical Functions

namedescription
absAbsolute-value function. The absolute value of a number is the number without its sign.
aCosArccosine function. The arccosine is the angle whose cosine is number.
arrayAvgCalculates the average of the values in an array.
arraySumArray sum function.
aSinDetermines the arcsine of a number. The arcsine is the angle whose sine is number.
atnArctangent function. The arctangent is the angle whose tangent is number.
bitAndPerforms a bitwise logical AND operation.
bitMaskClearPerforms a bitwise mask clear operation.
bitMaskReadPerforms a bitwise mask read operation.
bitMaskSetPerforms a bitwise mask set operation.
bitNotPerforms a bitwise logical NOT operation.
bitOrPerforms a bitwise logical OR operation.
bitSHLNPerforms a bitwise shift-left, no-rotation operation.
bitSHRNPerforms a bitwise shift-right, no-rotation operation.
bitXorPerforms a bitwise logical XOR operation.
ceilingDetermines the closest integer that is greater than a specified number.
cosCalculates the cosine of an angle that is entered in radians.
decrementValueDecrements the integer part of a number.
expCalculates the exponent whose base is e that represents number. The constant e equals 2.71828182845904, the base of the natural logarithm. This function is the inverse of Log, the natural logarithm of number.
fixConverts a real number to an integer.
formatBaseNConverts number to a string, in the base specified by radix.
incrementValueAdds one to an integer.
inputBaseNConverts string, using the base specified by radix, to an integer.
intCalculates the closest integer that is smaller than number. For example, it returns 3 for Int(3.3) and for Int(3.7); it returns -4 for Int(-3.3) and for Int(-3.7)
logCalculates the natural logarithm of a number. Natural logarithms are based on the constant e (2.71828182845904).
log10Calculates the logarithm of number, to base 10.
maxDetermines the greater of two numbers.
minDetermines the lesser of two numbers.
piGets the mathematical constant p, accurate to 15 digits.
precisionEvaluateEvaluates one or more string expressions, dynamically, from left to right, using BigDecimal precision arithmetic to calculate the values of arbitrary precision arithmetic expressions.
randGenerates a pseudo-random number.
randomizeSeeds the pseudo-random number generator with an integer number, ensuring repeatable number patterns.
randRangeGenerates a pseudo-random integer in the range between two specified numbers.
roundRounds a number to the closest integer that is larger than the input parameter.
sgnDetermines the sign of a number.
sinCalculates the sine of an angle that is entered in radians.
sqrCalculates the square root of a number.
tanCalculates the tangent of an angle that is entered in radians.