Functions

Introduction to Functions in Models

Overview

Models supports many of the Functions that you are used to using in Excel, from logical functions like IF() and AND(), to financial functions like XNPV() and IRR().

Example of an IF function in Models

In fact, all Models functions are Excel functions, meaning you can always generate working Excel spreadsheets from your Models.

You can also create custom functions using the LET/LAMBDA features, which are explained in the Advanced Functions section.

Not all Excel functions are fully supported in Models. You can still use non-supported functions to generate working Excel spreadsheets, but they will not show up in the AutoComplete dropdown, and Models will not be able to calculate values.

See the full list of supported functions below.

Entering a Function

The simplest way to create a Function is to simply type the Function name in the Formula Entry Bar.

Typing the name followed by an opening parentheses will create the relevant Calculation Parts, or you can select the Function from the AutoComplete dropdown - functions are indicated by the function symbol.

As in Excel, Function arguments are separated by commas.

List of supported Functions

See Excel documentation for full list of Excel functions.

Name
Excel Category
Microsoft Documentation

Last updated