Chapter 4-6: ILF Keyword Reference
CALC - Basic Functions
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 |