HOW TO: Use Functions in Formulas in Excel 2000

This step-by-step article explains how to use functions in formulas in Excel 2000.

A formula is an equation that performs operations on worksheet data. Formulas can perform mathematical operations, such as addition and multiplication, or they can compare worksheet values or join text. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order or structure. This article explains how to use functions in formulas.

Use Functions

When you are familiar with the functions that you want to use in a formula, you can type those functions in a cell. If you are unsure about which function you need to use, or if you want help to create the formula, follow these steps:

1. Click the destination cell (where you want the result to appear).
2. On the Insert menu, click Function.
3. Do one of the following:
   • In the Function category box, click a function category.
     
     -or-
   • In the Function category box, click All.
     
     -or-
   • Click the Help icon in the Paste Function window, click Help with this feature, type a brief description of the function that you want to use, and then click Search.
4. In the Function name box, click each function to get a description. When you have selected the one that you need, click OK.
5. Enter the information (arguments) by using one of the following methods:
   • Type a value or cell reference.
     
     -or-
   • Click the icon at the right end of the argument box to hide the dialog box, select the cell or cells on the worksheet, and then click the icon at the right end of the floating reference toolbar.
     
     -or-
   • On the Insert menu, click Function.
     
     -or-
   • On the Insert menu, point to Name, and then click Paste to use a named reference.
6. When you have entered the values for all of the required arguments (those in bold text) and any optional arguments that you need to use, click OK.

For more information about functions and formulas, click Microsoft Excel Help on the Help menu, type function formula in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.