Function Reference

@RISK includes a wide array of custom Excel functions (sometimes called Excel UDFs) that can be added directly into Excel cells and formulas. As a beginning @RISK user, it is easiest to use the @RISK interface to enter these functions, but more experienced users will often find that typing these function directly into the spreadsheet is faster.

@RISK functions can be classified in to several broad categories:

• Probability Distribution Functions - Includes all the univariate probability distribution functions supported in @RISK.
• Time Series Functions - includes all the time series functions supported in @RISK.
• Output Function - the RiskOutput function, used to mark cells so that after a simulation it can be analyzed in graphs, statistics, sensitivity analyses, etc.
• Statistic Functions - a collection of functions that return either theoretical, simulated result, or six-sigma statistics directly to the spreadsheet.
• Fitting Functions - and handful of functions for returning fit information directly to the spreadsheet.
• Property Functions - a set of “modifying” functions that change how other @RISK functions work.
• Miscellaneous Functions - a set of functions that don’t neatly fit into another category.