Home / Monte Carlo / Model Building / Supported Excel Functions

Supported Excel Functions

Quantum XL evaluates a simulation one of two ways: with Excel's own calculation engine, or with the Quantum XL Banyan-Tree Math Parser, which is more than 100 times faster.

This page lists the Excel functions the Banyan-Tree Math Parser reads. A model built from these functions runs in the Quantum XL Banyan-Tree Engine (Fast Mode).

A model that uses a function which is not on this list still simulates. It runs in Native Mode - Excel Calculated Monte Carlo instead, where Excel recalculates the whole workbook once for every simulation. Validate Model reports which of the two a given model will use, and names any formula the engine cannot read.

The functions

There are 89, grouped the way Excel groups them and alphabetical within each group.

Math

ABS, ATAN, COMBIN, COS, COSH, COTH, CSCH, DEGREES, EVEN, EXP, FACT, FLOOR, INT, LN, LOG, LOG10, MAX, MIN, MOD, ODD, PI, POWER, PRODUCT, QUOTIENT, RADIANS, ROUND, ROUNDDOWN, ROUNDUP, SECH, SIN, SINH, SQRT, SUM, SUMPRODUCT, TAN, TANH, TRUNC

Statistical

AVEDEV, AVERAGE, BETADIST, BETAINV, BINOMDIST, CHIDIST, CHIINV, COMBINA, COUNT, EXPONDIST, FDIST, FINV, GAMMADIST, GEOMEAN, HARMEAN, HYPGEOMDIST, LOGINV, LOGNORMDIST, MEDIAN, NEGBINOMDIST, NORMDIST, PERMUT, POISSON, STDEV, STDEVP, TDIST, TINV, VARP, WEIBULL

Engineering

BESSELI, BESSELJ, BESSELK, BESSELY

Financial

DB, DDB, EFFECT, FV, IRR, MIRR, NOMINAL, NPER, NPV, PMT, PV, SLN, SYD

Logical

AND, IF, IFERROR, OR

Information

ISERROR, ISNUMBER

The operators

+, -, *, /, ^, %, =, <>, <, <=, >, >=

A leading + or - is read as a sign. A trailing % divides by 100.

Text concatenation with & is not read by the parser.