Excel - How to Use Functions

This document explains how to use and edit functions in all versions of Microsoft Excel.

To perform a mathematical function on a group of cells, follow these steps:

  1. Select the cell that will contain the answer. All functions in Excel start with an equals sign, =.
  2. Type in the function that you would like to calculate. You can select a cell or group of cells as variables.

    For example, to add the value in cell A1 to the value in cell A2, you can type in the function =A1 + A2.

    An alternative method:

    1. Type =
    2. Select cell A1 with the mouse
    3. Type +
    4. Select cell A2 with the mouse

  3. Press Enter on the keyboard when you are done and wish Excel to calculate the answer.

To edit a function after it has been created:

  1. Select the cell that contains the function. The calculated answer will be displayed in the cell.
  2. Click on the Formula Bar.

    940formulabar.PNG

    After clicking in the Formula Bar, the function itself will now be displayed in the cell. You can edit the function from in the cell or in the formula bar. After the changes have been made, press Enter to calculate and display the new answer in the cell.

Using pre-defined functions:

Excel also contains a number of pre-defined functions. To access these, click the Fx button on the Standard Toolbar, or select Function from the Insert menu.

For example, the Sum function can be used to add up a range of cells.

  1. Select the cell that is to contain the answer.
  2. Type in =sum(

    Two alternative methods:

    • Click the Fx button
          or
    • Select Insert->Function from the menu bar

  3. Select the range of cells that the function is to be performed upon. You can also enter this directly by typing in the first cell in the range, a colon and then the last cell in the range - for example (A1:A2).
  4. Type in a close parenthesis, ).
  5. Press Enter on the keyboard to calculate and display the answer.



Keywords:excel microsoft mathematical functions fx group cells   Doc ID:25582
Owner:Andrei M.Group:DoIT Help Desk
Created:2012-08-11 18:57 CDTUpdated:2014-09-30 16:47 CDT
Sites:DoIT Help Desk, Southern Illinois University Edwardsville
Feedback:  20   19