abs

Return the absolute value of the parameter

double

abs(double val)

acos

Inverse cosine function, parameter range [-1,1]

double

acos(double val)

acosh

Inverse hyperbolic cosine

double

acosh(double val)

asin

Arc sine function, parameter range [-1,1]

double

asin(double val)

asinh

Inverse hyperbolic sine

double

asinh(double val)

atan

Arc tangent function

double

atan(double val)

atan2

Returns the arc tangent of the specified x and y axes

double

atan2(double x,double y)

atanh

Inverse hyperbolic tangent, parameter range (-1,1)

double

atanh(double val)

ceiling

Returns the parameter val rounded up (in the direction of absolute absolute increase) to the nearest multiple of significance

double

celling(double val, double significance)

combin

Calculate the number of combinations of objects extracted from a given number of object collections

double

combin(double val, double chosen)

cos

Return the cosine of the parameter

double

cos(double val)

cosh

Hyperbolic cosine function

double

cosh(double val)

degrees

The function returns the degree of arc angle

double

degrees(double val)

even

The function returns the nearest even after rounding in the absolute value increase direction

double

even(double val)

exp

Function returns exponential value with e

double

exp(double val)

fact

Return the factorial value of the parameter

double

fact(double val)

factdouble

Returns the double value of the parameter's factorial

double

factdouble(double val)

floor

The return parameter val is rounded down in the direction of decreasing absolute value, making it equal to the nearest multiple of Significance

double

floor(double val, double significance)

gcd

Returns the greatest common divisor of two or more integers.

int

gcd(Object numbersObj)

integer

Logarithm rounding

int

integer(double val)

lcm

Returns the least common multiple of an integer argument

int

lcm(double val)

ln

Return the natural logarithm of the argument

double

ln(double val)

log

Returns the base value of the logarithm

double

double log(double val, double base)

log10

Returns the base 10 logarithm value

double

log10(double val)

mdeterm

Returns the value of the matrix determinant of an array

double

mdeterm(Object valuesObj)

mod

Returns the remainder of division by two numbers

double

mod(double val, double divisor)

mround

Returns the value of the parameter rounded to the specified base

double

mround(double val, double multiple)

multinomial

Get the factorial of the sum of the parameters and divide by the product of the factorials of the parameters, such as a1 + a2+... +an)!/(a1!*a2!....an!)

double

multinomial(Object valuesObj)

odd

Returns the odd number after the specified number is rounded up

int

odd(double val)

pi

Return PI value

double

pi()

power

Returns the power of a given number

double

power(double val, double power)

mathproduct

Returns the number multiplied by the argument and returns the product value.

double

mathproduct(Object valuesObj)

quotient

Returns the quotient of (int)(value/denominator)

int

quotient(double value,double denominator)

radians

Radius angle of degree returned

double

radians(double angle)

rand

Returns a uniformly distributed random number greater than or equal to 0 and less than 1, in the range [0,1)

double

rand()

randbetween

Returns a random integer greater than or equal to the specified minimum value, less than the specified maximum value

int

randbetween(int start, int end)

round

Returns the number of digits rounded to the specified number of digits

double

round(double val, int accurate)

rounddown

Decrements digits by the specified number of digits after the specified number of digits

double

rounddown(double val, int accurate)

roundup

Rounds up to the specified number of digits by the specified number of digits

double

roundup(double val, int accurate)

seriessum

Returns the sum of power series

double

seriessum(double x, double n, double m, Object coefficientsObj)

sign

Returns the sign of a number. Returns 1 if the number is positive, 0 if it is zero, and -1 if it is negative

int

sign(double val)

sin

Return the sine of the parameter

double

sin(double val)

sinh

Returns the hyperbolic sine of a parameter

double

sinh(double val)

sqrt

Returns the square root of the argument

double

double sqrt(double val)

sqrtpi

Returns the square root of the product of the argument and pi

double

sqrtpi(double val)

subtotal

Return subtotals in data lists or databases, function value constants with function_id [1,11]

double

subtotal(int function_id, Object valuesObj)

mathSum

Return the sum of parameters

double

mathSum(Object valuesObj)

sumif

Summing several cells according to specified conditions

double

sumif(Object valuesObj, String criteria, Object sumValuesObj)

sumproduct

In a given set of arrays, the corresponding elements of the array are multiplied and the sum of the products is returned.

double

sumproduct(Object arraysObj)

mathSumsq

Returns the square of the argument

double

mathSumsq(Object valuesObj)

sumx2py2

Returns the sum of the squared differences of the corresponding values in the two arrays

double

sumx2py2(Object arrayObj1, Object arrayObj2)

sumxmy2

Returns the sum of the squares of the difference between the corresponding values in two arrays

double

sumx2py2(Object arrayObj1, Object arrayObj2)

sumx2my2

Returns the sum of the squared differences of the corresponding values in two arrays

double

sumx2my2(Object arrayObj1, Object arrayObj2)

tan

Return the tangent of the parameter

double

tan(double val)

tanh

Returns the hyperbolic tangent of the argument

double

tanh(double val)

trunc

Truncates the decimal part of a number and returns an integer

double

trunc(double val)