O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with functions

As you’ve already seen in this section, functions are the engines that drive your formulas. They do the actual processing, whether the formula calls for simple or complex calculations. When you add a function to a formula, the function needs to know which cells to use in the calculation.

Find the function you want

  1. Click the cell in which you want to add the function and then click the Formulas tab.

  2. On the far left side of the Function Library group, click the Insert Function button.

    The Insert Function dialog box opens.

  3. Click the category down arrow to display the drop-down list and then select the function category that you want to view.

    You can choose from All, Financial, Date & Time, Math & Trig, Statistical, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required