excel functions, how to use excel functions, guide, tips
Home About Us Reference Product Service Sitemap

Excel: How to use functions?

Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order or structure. This tutorial explains how to use functions in formulas.

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:

1)In the Function category box, click a function category.


2) In the Function category box, click All.


3) 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:

1) Type a value or cell reference.


2) 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.


3) On the Insert menu, click Function.


4) 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.

©1994 - 2010 Edusoftmax Inc. All rights reserved. Questions? Comments?    Visitors: