How to Insert a Function in Google Sheets

There are hundreds of functions available for you to perform just about any kind of calculation. Functions are sorted into categories that you can browse.

Insert a Function

1. Click in the cell where you want to add a function.
2. Click Insert on the menu bar.
3. Select Function.
4. Select a category.
5. Select a function.
   

   Most functions require some kind of input or data to calculate, called arguments.

6. Enter the function's arguments.
   
7. Press Enter.

The function is applied to the selected cell.

Get Help on Functions

If you're not sure what category a certain function is found in, you can consult the Google Sheets function list page to find out.

1. Click Insert on the menu bar.
2. Select Function.
3. Select Learn more.
   

A new browser tab opens to the function list. You can scroll through this list to see all of the available functions, their syntax, and a description of what they do.

4. Enter keywords in the search field.
   

Sheets displays information about the topic you entered.