Function

Description

Example

@ABS(X)

Returns the positive value of X, regardless of the sign of X.

@ABS(3) = 3

@ABS(-3) = 3

@CEIL(X)

Returns the smallest integer not less than X.

@CEIL(-2.1) =-2

@CEIL(-2.0) =-2

@CEIL(0) = 0

@CEIL(2.0) = 2

@CEIL(2.1) = 3

@FLOOR(X)

Returns the largest integer not greater than X.

@FLOOR(-2.1) =-3

@FLOOR(-2.0) =-2

@FLOOR(0) = 0

@FLOOR(2.0) = 2

@FLOOR(2.1) = 2

@MOD(X,Y)

Returns the remainder of X divided by Y. Y cannot be zero. The result has the same sign as X, regardless of the sign of Y.

@MOD(5,2) = 1

@MOD(-5,3) =-2

@MOD(10,5) = 0

@MOD(5,0) = ERROR

@POW(X,Y)

Returns the value of X raised to the power of Y. An error occurs if zero is raised to the zero or a negative power, or if a negative number is raised to a non-integer power. Overflow and underflow errors are also possible, especially with large values of Y.

@POW(5,2) = 25

@POW(1.5,2.5) = 2.755676...

@POW(25,-.5) = .2

@POW(0,2) = 0

@POW(0,0) = ERROR

@POW(0,-2) = ERROR

@POW(-.6,2.5) = ERROR

@POW(12345,67890)=OVERFLOW

@POW(.12345,67890)=UNDERFLOW

@SQRT(X)

Returns the square root of X. An error occurs if X is negative. This function is equivalent to @POW(X,.5).

@SQRT(9) = 3

@SQRT(2) = 1.414...

@SQRT(0) = 0

@SQRT(-2) = ERROR