Creating Functions

graphics/microsoft16.gif

Trying to write a formula that calculates various pieces of data, such as calculating payments for an investment over a period of time at a certain rate, can be difficult and time-consuming . The Insert Function feature simplifies the process by organizing Excel's built-in formulas, called functions, into categories so they are easy to find and use. A function defines all the necessary components (also called arguments) you need to produce a specific result; all you have to do is supply the values, cell references, and other variables . You can even combine one or more functions if necessary.

Enter a Function Using Insert Function

graphics/one_icon.jpg

Click the cell where you want to enter the function.

graphics/tow_icon.jpg

Click the Insert Function button on the Formula bar.

graphics/three_icon.jpg

Click a function category you want to use.

graphics/foure_icon.jpg

Click a function you want to use.

graphics/five_icon.jpg

Click OK.

graphics/six_icon.jpg Enter the cell addresses in the text boxes. Type them or click the Collapse Dialog button to the right of the text box, select the cell or range using your mouse, and then click the Expand Dialog button.

In many cases, the Insert Function might try to "guess" which cells you want to include in the function.

graphics/seven_icon.jpg

Click OK.

graphics/03inf30.jpg

graphics/03inf31.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net