Mathematical Spreadsheet Functions
All of the arguments of these functions (x, y, z, s, and w) are expressions. Series and array subranges are allowed in any argument requiring a series or array (without subscripts).
| DPL | Excel | Action |
|---|---|---|
| @abs(x) | ABS(x) | The absolute value of x. |
| @exp(x) | EXP(x) | The number e (2.718281828459045) raised to the xth power. If the argument of @exp( ) is larger than 709, the function will produce a number larger than DPL can store or process. |
| @int(x) | TRUNC(x) | The integer part of x. |
| xlint(x) | INT(x) | Rounds x down to the nearest integer. |
| @ln(x) | LN(x) | The natural logarithm (base e) of x. Not defined if the argument is 0 or negative. |
| @log(x) | LOG(x),LOG10(x) | The logarithm (base 10) of x. Not defined if the argument is 0 or negative. |
| @mod(x,y) | MOD(x,y) | The remainder when x is divided by y. The second argument cannot be 0. |
| xlmod(x,y) | MOD(x,y) | The remainder when x is divided by y. The second argument cannot be 0. |
| @pi | PI( ) | The number pi (3.141592653589793). This function does not take an argument or parentheses. If you place parentheses after it, DPL will generate an error message. |
| @round(x,y) | ROUND(x,y) | x rounded to y places. |
| @sqrt(x) | SQRT(x) | The positive square root of x. Not defined if its argument is negative. |
| xltranspose(s) | TRANSPOSE(s) | The transpose of the series or array s. |
Notes: This information is subject to change. New functions are added from time to time. Contact technical support for the latest compatibility information.
Versions: DPL Professional, DPL Enterprise, DPL Portfolio
See Also