This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?
To create a basic worksheet, some of the core tasks involve entering formulas and functions. Both formulas and functions are instructions for Excel to do calculations for you by referring to values in the worksheet or within the formula.
There are multiple ways you can create a function. You can insert functions manually (by typing them), or you can use the Insert Function dialog box. The Insert Function dialog box eliminates the possibility of a typing error, so it is the recommended method. For more information on formulas, refer to Performing Calculations in Your Workbook.
Determining what functions are available, what function you should be using, and what you need to include in the function is easier with the Insert Function dialog box. The Insert Function dialog box will display a listing of all functions or categories of functions available with Excel. As you select a function (as in the following graphic), a sample of the function appears at the bottom of the dialog box. As you make your selection, the Insert Function dialog box will request certain types of information. You simply select the cells where that information is located.
Windows:
Place the cell pointer on the cell where the formula should be added
From the Insert menu, select Function…
The Insert Function dialog box appears.
From the Or select a category pull-down list, select the appropriate function category or All
From the Select a function scroll box, select the desired function
HINT: A description of the selected function appears beneath the Select a function scroll box.
Click OK
The Function Arguments dialog box appears.
In the text boxes, type the data to be in the function
HINTS:
To hide the dialog box so you can select cell ranges with the mouse rather than type them, click COLLAPSE DIALOG.
To restore the dialog box, click RESTORE DIALOG.
Click OK
Macintosh:
Place the cell pointer on the cell where the formula should be added
From the Insert menu, select Function…
The Paste Function dialog box appears.
From the Function category scroll box, select the appropriate function category or All
From the Function name scroll box, select the desired function
HINT: A description of the selected function appears beneath the Function category scroll box .
Click OK
The Function Arguments dialog box appears.
In the text boxes, type the data to be in the function
HINTS:
To hide the dialog box so you can select cell ranges with the mouse rather than type them, click COLLAPSE DIALOG.
To restore the dialog box, click EXPAND DIALOG.
Click OK
The Function Arguments dialog box helps you to enter worksheet functions. As you type the function, the Function Arguments dialog box displays the name of the function, the function arguments, a description of the function and its arguments, and the result of the function. Once you have entered a function, you can further edit it using the Function Arguments dialog box.
Select a cell containing a function
On the Formula bar, click INSERT FUNCTION
The Function Arguments dialog box appears.
Formulas based on cell references can be "written" by pointing to the cells rather than typing the cell entries. This "point" method can help reduce the chance of error in the formulas and sometimes may make more sense. The point method may not work as well when the cells in question are located in different areas of the worksheet, but the method can be used then as well.
The key to the point method is to point to click the cells to be included and to type the operators where appropriate.
The following examples provide step-by-step instructions for a simple addition of two cells and for adding a range of cells.
Place the insertion point in the cell where the results should be displayed
To start the function, press [=]
Point and click the first cell to be added
Press [+]
Point and click the next cell to be added
Repeat steps 4-5 as necessary
Press [Enter] or [return]
Place the insertion point in the cell where the results should be displayed
To start the function, press [=]
Type SUM(
Point and click the first cell in the range to be added
Press [:]
Point and click the last cell to be added
Type )
Press [Enter] or [return]
Place the cell pointer in the cell where the results should be displayed
To start the function, press [=]
Type SUM(
Click and drag the mouse to select the range of cells to be added
Type )
Press [Enter] or [return]