How to insert functions into formulas

Excel 365 2013 2010 2007 2003
The easiest way to enter a function into a formula is to use the Excel program's Insert Function dialog box.

You can insert a function of the following methods:

  • On the Formulas tab, in the Function Library group, choose the Insert Function command or one of the following:
    Function Library in Excel 2016
  • Click the Insert Function button Insert Function button in the left of the Formula bar:
    Edit bar Excel 2016
  • Press Shift+F3 for selecting the function from the Insert Function dialog box:
    Insert Function in Excel 2016

See also this tip in French: Comment insérer des fonctions dans des formules.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.