What Functions are Exported to Microsoft Excel?

Question

What functions are exported to Microsoft Excel?

Application Area

Formulas configured in a regular report can be exported to Microsoft Excel as formulas. If a function included into a formula is not supported in Microsoft Excel, text or numeric value is displayed in a formula cell.

Source Data

A regular report containing formulas.

Solution

The following functions are exported to Microsoft Excel:

Mathematical Functions

References and arrays

Date and time

Text

Financial

Statistical

Logical

IMPORTANT. The given list of functions with Microsoft Excel analogs is relevant for the *.xlsx format, the list of analogs for the *.xls format is limited.

See also:

Report Export | Using Formulas