Insert Functions

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order or structure.

Example: The SUM function adds values or ranges of cells, and the PMT function calculates the loan payments based on an interest rate, the length of the loan, and the principal amount of the loan.

A function begins with the function name, followed by an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis. If the function starts a formula, type an equal sign (=) before the function name. As you create a formula that contains a function a Function Arguments dialog box will appear to assist you.

• Arguments can be numbers, text, logical values such as TRUE or FALSE, arrays, error values such as #N/A, or cell references.
• The argument you designate must produce a valid value for that argument.
• Arguments can also be constants, formulas, or other functions.

To enter a formula using functions:

• Click on the cell where you want the result of the formula.
• Click the button on the Icon Formula Bar. This opens the Insert Function dialog box.
  

• Double-click a Function to select it.
• Click OK and the Function Argument dialog appears. This dialog box will ask you to provide the necessary information to complete the function.
  

• Enter the cell addresses for your calculation. This can be accomplished by:
• Using your mouse to drag over an appropriate range of cells.
• Using the function argument fields.
• Once you have finished, press enter.

Arguments can also be constants, formulas, or other functions.