Enter using the Function pane

Application: Spreadsheet Home Edition

To enter a function using the Insert function pane, follow these steps:

1.Select the cell in which you want to enter a function.

2.Expand the Insert function pane in one of the following ways:

•In the Formula bar, click side_panel_function .

•On the Insert tab, click t_insert_formulas Group.

•On the Sidebar, click side_panel_function Insert function.

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

•Press Shift+F3.

3.Find the required function in one of the following ways:

•Enter part of the function name/the whole name in the search field. Below is a list of functions that meet the search conditions.

•Select the group that the function belongs to. For example, the SUM function is included in the Math & trig group.

•Find the function in one of the following groups:

oAll: Contains all functions supported by MyOffice Spreadsheet.

oRecent: Contains the last 10 functions entered by the user.

oMost popular: Contains a fixed list of 10 frequently used functions.

4.Select the required function.

5.If necessary, check out the function summary at the bottom of the Insert function pane.

6.To insert a function into a cell, do one of the following:

•Click Paste.

•Select the function by double-clicking.

•Press Enter.

7.In the Function arguments window that opens, enter the arguments directly into the value fields, or by clicking select_cells Select values, select a range of values with the mouse, then click Select values again or press Enter to confirm the entry. When entering a function in MyOffice Spreadsheet, you can select an entire column, a range of columns, an entire row, or a range of rows as an argument by selecting their titles.

If in Windows, in the Customize format window, "." is selected in the Decimal symbol field, then in MyOffice Spreadsheet, use "," instead of ";" as the separator of values in functions.

8.There are several ways to complete the function entry:

•To confirm the input, click OK in the Function arguments window, the accept_icon button in the Formula bar, or press Enter.

•To cancel function entry, click Cancel in the Function arguments window, click the reject_icon button in the Formula bar, or press Esc.

9.To close the Insert Function pane, do one of the following:

•In the Formula bar, click side_panel_function .

•On the Insert tab, click t_insert_formulas Group.

•On the Sidebar, click side_panel_function Insert function.

•Click fp_header_back_icon in the upper part of the Insert function pane.

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

•Press Shift+F3.

Was this helpful?

Yes