Skip to main content

Enter a function using the Insert function pane

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

  1. Select the cell in which you want to enter a function. If a range is selected, the function will be entered into the active cell.

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

    • On the Formula bar, click function_button.
    • On the Insert tab, click t_insert_function Function.
    • On the Sidebar, click function_button Insert function.
    • Press Shift+F3.

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

    • Enter part of the function name or the entire name in the Find box. 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: All: Contains all the functions supported by MySpreadsheet. Recent: Contains the last 10 functions entered by the user. Most 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 Insert.
    • Select the function by double-clicking.
    • Press Enter.

func_side_panel_edu

  1. 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_cells  Select values again or press Enter to confirm the entry. When entering a function, 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. When you select a row, column, or range of cells with the mouse as an argument for a function, a tooltip appears with information about the size of the selected area. The tooltip is displayed as long as the left mouse button remains held down.
warning

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

func_arguments_window

  1. 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.

  2. To close the Insert function pane, do one of the following:

    • On the Formula bar, click function_button.
    • On the Insert tab, click t_insert_function** Function**.
    • On the Sidebar, click function_button Insert function.
    • Click fp_header_back_icon in the upper part of the Insert function pane.
    • Press Shift+F3.