Enter functions

Enter functions into a cell or formula bar

1.Select the cell where you want to enter a function.

2.In the formula bar on in the cell, enter the equal sign (=).

3.Start entering the name of the function to open the list of available functions.

4.Select the function you want to use from the list.

5.Enter the function arguments.

6.Press Enter to finish entering the function.

Enter functions using the Sidebar

1.Select the cell where you want to enter the function.

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

•On the Command menu, select Insert > Function.

•Click  More on the Toolbar and select Insert > Function from the drop-down list.

•On the Sidebar, click the Insert function button.

•In the formula bar, click Insert Function.

3.In the search box, start typing the name of the function.

4.Select the function you want to use from the list.

5. If needed, read the short information about the function in the lower part of the Sidebar.

6. Click Paste or Enter to insert the function.

7. Enter the function arguments.

8. Press Enter to finish entering the function.

To cancel the search by the entered function name, click in the search box.

When working with numeric data, users can use the Autosum feature, which includes five popular data processing functions: SUM, MIN, MAX, AVERAGE, COUNT. When this feature is executed, a range of cells with numeric data is automatically recognized and used in the respective function. Where the result of the calculation is displayed and what range of data is used is determined by the cells selected before executing the function.

To calculate the sum for a column, do one of the following:

•Select an empty cell under the column. The result will be inserted into this cell.

•Select the entire column. The result will be inserted into the empty cell closest to the range under the column.

•Select a range of cells if you want to use only part of the cells in the calculation. The result will be inserted into the empty cell closest to the range under the column.

For horizontal ranges, the function works in the same way.

To enter a function using the Autosum function, follow these steps:

1.Select an empty cell next to the data, column, row, or range of cells.

2.Call the Autosum function in of the following ways:

•Click the  Autosum button on the formula bar or on the Toolbar, in the Data section.

•In the Command menu, select Data > Autosum.

•Press Alt+= ( Option+=) on the keyboard.