Ø @ABS(X) -
The absolute value of X.
Ø @ACOS(X) -
The arc cosine of X.
Ø @ASIN(X) -
The arc sine of X.
Ø @ATAN(X) -
The 2-quadrant arc tangent of X.
Ø @ATAN2(X, Y) -
The 4-quadrant arc tangent of Y/X.
Ø @CEIL(X) -
The smallest integer greater than or equal to X.
Ø @COS(X) -
The cosine of X.
Ø @COSH(X) -
The hyperbolic cosine of X.
Ø @DEGREES(X) -
Converts the angle expressed in radians to degrees ( ).
Ø @DET(M) -
The determinant of the matrix range M, which must be a square matrix.
Ø @DOT(R1, R2) -
The dot product of the vectors R1 and R2.
Ø @EXP(X) -
e raised to the X power.
Ø @FACT(N) -
The value of N!.
Ø @FLOOR(X) -
The largest integer less than or equal to X.
Ø @FRAC(X) -
The fractional portion of X.
Ø @GAMMA(X) -
The value of the gamma function evaluated at X.
Ø @GRAND -
A 12th-degree binomial approximation to a Gaussian random number with zero mean and unit
variance.
Ø @INT(X) -
The integer portion of X.
Ø @LN(X) -
The natural log (base e) of X.
Ø @LNGAMMA(X) -
The log base e of the gamma function evaluated at X.
Ø @LOG(X) -
The log base 10 of X.
Ø @LOG10(X) -
The log base 10 of X.
Ø @LOG2(X) -
The log base 2 of X.
Ø @MOD(X, Y) -
The remainder of X/Y.
Ø @MODULUS(X, Y) -
The modulus of X/Y.
Ø @PI -
The value of p.
Ø @POLY(X, ...) -
The value of an Nth-degree polynomial in X.
Ø @PRODUCT(X, ...) -
The product of all the numeric values in the argument list.
Ø @RADIANS(X) -
Converts the angle expressed in degrees to radians ( ).
Ø @RAND -
A uniform random number on the interval [0,1).
Ø @ROUND(X, n) -
X rounded to n number of decimal places (0 to 15).
Ø @SIGMOID(X) -
The value of the sigmoid function.
Ø @SIN(X) -
The sine of X.
Ø @SINH(X) -
The hyperbolic sine of X.
Ø @SQRT(X) -
The positive square root of X.
Ø @SUMPRODUCT(R1, R2) -
The dot product of the vectors R1 and R2, where R1 and R2 are of equal dimension.
Ø @TAN(X) -
The tangent of X.
Ø @TANH(X) -
The hyperbolic tangent of X.
Ø @TRANSPOSE(M) -
The transpose of matrix M.
Ø @VECLEN(...) -
The square root of the sum of squares of its arguments.