How can we help you?

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 More on the Toolbar and select Insert > Function from the drop-down list.

On the Sidebar, click the button_function Insert function button.

In the formula bar, click fx_button 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.

1.Click Paste or Enter to insert the function.

2.Enter the function arguments.

3.Press Enter to finish entering the function.

To cancel the search by the entered function name, click clear_iconin the search box.
Was this helpful?
Yes
No
Previous
Automatic calculation
Next
Copy and insert formulas