Function Wizard

To work with functions, click the

Insert Function button in the formula bar or press SHIFT+F3.

After executing the operation, the Function Wizard dialog box opens:

To work with the function wizard:

Select function category in the side menu list:

Full Alphabetic List. All existing functions.
Mathematical. Mathematical functions.
References and Arrays. Functions for working with references and arrays.
Date and Time. Functions for working with date and time.
Text. Functions for working with strings.
Report. Functions for working with report slices.
Finance. Financial functions.
Statistical. Statistical functions.
Logical. Logical functions.
Python. Calling Python functions.
Java. Calling Java functions.
Custom. They can be used to enhance regular report capabilities due to the use of custom calculation methods.

NOTE. Functions in each category are ordered alphabetically.

To quickly search for a function, enter part of its name or a full name to the Search box.

When a function is selected, the area under the functions list displays its structure and brief description.

After a function is selected, its parameters can be set up.

Set values of parameters of the selected function at the right part of the function wizard window.

If parameter is a number, both number and cell address where it is located can be determined in the parameter edit box. In the parameter input the arithmetic symbols can be used: +, -, /, *, >, <, =.

NOTE. The edit box can contain only one relation operation: =, <>, >, <, >=, <=.

When a parameter is set, the area under edit boxes displays parameter structure and brief description.

Initially, the edit box only for one argument is displayed for the functions with variable number of arguments (for example, the Sum, And functions).

When the second field gets focus, a field for the third argument is added, and so on. Maximum number of arguments - 255:

Click the Apply button.

After executing the operations, result of calculating the specified function will be contained in the regular report cell.