Functions

When using Excel functions play an important role in finding values for a range of cells. Learn all about using functions in Excel.

Using functions

There are a variety of functions. Here are some of the most common functions you'll use:

To use a function:

In our example below, we'll use a basic function to calculate the average price per unit for a list of recently ordered items using the AVERAGE function.

  1. Select the cell that will contain the function. In our example, we'll select cell C11.
    Screenshot of Excel 2013
  2. Type the equals sign (=) and enter the desired function name. In our example, we'll type =AVERAGE.


    Screenshot of Excel 2013
  3. Enter the cell range for the argument inside parentheses. In our example, we'll type (C3:C10). This formula will add the values of cells C3:C10 and then divide that value by the total number of cells in the range to determine the average.


    Screenshot of Excel 2013
  4. Press Enter on your keyboard. The function will be calculated, and the result will appear in the cell. In our example, the average price per unit of items ordered was $15.93.


    Screenshot of Excel 2013

Your spreadsheet will not always tell you if your function contains an error, so it's up to you to check all of your functions. To learn how to do this, check out the Double-Check Your Formulas lesson.