# 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*