Insert a Function in Excel

How to Insert Functions in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Insert a Function in Excel

Excel has over 450 functions you can use to perform just about any kind of calculation. If you're having trouble finding the right function, the Insert Function command lets you search for the function you want. It also guides you through inserting the arguments, which is helpful for complex functions.

  1. Click the cell where you want to add a formula.
  2. Click the Insert Function button.
  3. Search for a function using one of these methods:
    • Type a few keywords that describe the function you want and click Go.
    • Select a category from the list arrow menu.
  4. Select the desired function.
  5. Click OK.
    Insert Functions

    The Function Arguments dialog box appears. Here you need to specify the arguments for the function you selected. In Excel, an argument can be a range of data, a specified output, or other parameters.

    If you're ever confused about what an argument is, just check the description down here.

  6. Enter the formula arguments.
  7. Click OK. Insert Functions

The dialog box closes and Excel displays the results of the inserted formula.