Show TOC

To create a formulaLocate this document in the navigation structure

Context

To create a formula with Analysis functions:

Procedure

  1. Select the cell in which you want to enter the formula.
  2. To start the formula with a function, press the Insert Function button on the formula bar.
    The Insert Function dialog box appears.
  3. Select Analysis in the Select a category box.
  4. Select a function.
  5. Press OK.
    The Function Arguments dialog box appears.
  6. Enter the arguments.
    To enter cell references as an argument, press the Collapse Dialog button (which temporarily hides the dialog box), select the cells on the worksheet, and then press the Expand Dialog button.
  7. When you complete the formula, press OK.