View and edit formulas

To view and edit a function using the Function wizard window, follow the steps below:

1.Select a function using one of the following methods:

•Select the cell containing the function. If there is a complex formula in the cell, the first nested function in the Function wizard will be opened.

•Select the cell containing the function and, after entering the cell edit mode, place the text cursor on the desired function. The selected function is bolded in the Formula bar.

•Select the cell containing the function and, moving to the Formula Bar, place the text cursor on the desired function. The selected function is bolded in the Formula bar.

2.Open the Function arguments window in one of the following ways:

•In the Formula bar, click .

•On the Insert tab, click  Function.

•When working in macOS, select the Insert > Function command from the command menu.

•Press Shift+F3.

3.If a cell with a complex formula has been selected, use the  Next function and  Previous function buttons to switch between nested functions. The currently selected function is highlighted in color in the formula structure.

4.If necessary, make changes and click OK.

When working with the Function wizard, arguments are input into the value boxes of the Function arguments window. Arguments can be entered directly from the keyboard or by clicking  Select Values and then selecting a range of values with the mouse.

The data type, for example, “Number”, is displayed to the right of the input box. After entering an argument, the entered value, the calculated value, or a sequence of values is also displayed there. If an incorrect data type or nested function calculation error occurs, the error type is displayed to the right of the field, for example, “#NAME?”.

The Function result box at the bottom of the window displays the calculated value of the selected function, and the Formula result box displays the calculated value of the formula entered in the cell. If a simple formula is entered in the cell, the result of the function will match the value of the formula. If arguments are entered incorrectly, the error type will be displayed in these fields.