Functions

XLReporting supports 280 functions. Most functions are compatible with Microsoft Excel, and adhere to identical syntax and parameters. On top of Excel-compatible functions, XLReporting also provides 100+ special functions that uses unique functionality in XLReporting. These functions are marked by ❖ XLReporting. You can use functions anywhere in imports, reports, models, and queries.

Select by type:

All Text Date Number Aggregate Filters Lookups Period Queries Math System Financial Conditional Common Special

Or select alphabetically:

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z



Recommended reading:
Back to top | Imports | Reports | Models

We value your privacy

We use cookies to enhance your browsing experience and analyze our traffic.
By accepting, you consent to our use of cookies.

Accept Reject Cookie Policy