Microsoft KB Archive/304423

= HOW TO: Use Functions in Formulas in Excel 2000 =

Article ID: 304423

Article Last Modified on 1/7/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q304423



IN THIS TASK
SUMMARY
 * Use Functions

REFERENCES



SUMMARY
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.

back to the top

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:
 * 4) * In the Function category box, click a function category.

-or-
 * 1) * In the Function category box, click All.

-or-
 * 1) * 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.
 * 2) In the Function name box, click each function to get a description. When you have selected the one that you need, click OK.
 * 3) Enter the information (arguments) by using one of the following methods:
 * 4) * Type a value or cell reference.

-or-
 * 1) * 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-
 * 1) * On the Insert menu, click Function.

-or-
 * 1) * On the Insert menu, point to Name, and then click Paste to use a named reference.
 * 2) 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.

back to the top

