## Decision Analysis

### The Decision Analytic Advantage

### Here's why you should opt for a decision analytic approach

### The Decision Analytic Process

### Take a quick visual tour of a typical decision analytic process

### DPL Tutorial Videos

### Quickly learn DPL modeling basics via a series of six software video tutorials

### Decision Analytic Videos

### Learn about basic decision analytic tools and concepts via short, simple video tutorials using DPL

## Products

### Product Comparison

### Which version of DPL is right for you?

### What's New in DPL 9

### From game-changing analytics to modeling ease of use

### DPL Product Versions

### DPMX

### A decision analytic portfolio management system

### FREE DPL Pro Trial

### Get started with your FREE DPL Pro Trial today!

### FREE DPL Fault Tree Trial

### Get started with your FREE DPL Fault Tree Trial today!

### Order DPL Now

### Start making better decisions for your business today!

## Industries

### All Industry Examples

### View Real-world DPL Examples by Industry

### Customers

### See our list of satisfied customers by industry.

### Partners

### See a list of experienced consultants who use DPL

## Support

### Register DPL

### Get the latest support & product update information

### Downloads

### Knowledge Base

### Training

### Online, group & customized training on DPL

### Purchase Support

### Don't take unnecessary risks! Keep your DPL Support plan current.

## About Syncopation

### Company History

### Find out more about DPL software's history -- one that spans over 20 years

### Our People

### Meet the folks behind the DPL Software

### Opportunities

### Discover opportunities at Syncopation Software

# DPL 9 Help

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