Microsoft Office Tutorials and References
In Depth Information
Performing Calculations Using Functions
Performing Calculations Using Functions
Functions are predesigned formulas that save you the time and trouble of creating com-
monly used or complex equations. Excel includes hundreds of functions that you can use
alone or in combination with other formulas or functions. Functions perform a variety of
calculations, from adding, averaging, and counting to more complicated tasks, such as cal-
culating the monthly payment amount of a loan. You can enter a function manually if you
know its name and all the required arguments, or you can easily insert a function using
AutoComplete, which helps you select a function and enter arguments with the correct
Enter a Function
Click the cell where you want to enter the function.
Type = (an equal sign), type the name of the function, and then type ( (an open-
ing parenthesis).
As you type, you can scroll down the Formula AutoComplete list, select the
function you want, and then press Tab.
Type the argument or select the cell or range you want to insert in the function,
and then type ) (a closed parenthesis) to complete the function.
Click the Enter button on the formula bar, or press Enter.
Search JabSto ::

Custom Search