Function Wizard

The list of categories depends on the category selected in the Category drop-down 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. Function call in the Python language.

• Custom. Functions to enhance features of regular report by using custom calculation methods.

NOTE. Functions in each category are ordered alphabetically.

On selecting a function, function construction an brief descriptions appear under the Select Function list.

After a function is selected, click the OK button. The second page of function wizard opens.

The second page of function wizard looks as follows:

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

NOTE. The input field can contain only one relation operation: =, <>, >, <, >=, <=.

If invalid expression is set as parameter, the input field will be highlighted.

To finish the wizard work, define values of all the required parameters and click the OK button. The created formula appears in the formula bar, and the result of formula calculation is shown in the cell.

When a function has a variable arguments number (for example, Sum or And function) the second stage of the wizard initially shows two arguments with corresponding labels. Labels depend on argument type, for example:

• Number1, Number2, and so on. - for numeric arguments.

• String1, String2, and so on. - for string arguments.

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