Microsoft Office Tutorials and References
In Depth Information
See subsequent chapters for specific examples of using the functions.
The financial functions enable you to perform common business calculations that deal with
money. For example, you can use the PMT function to calculate the monthly payment for a car
loan. (You need to provide the loan amount, interest rate, and loan term as arguments.)
Date and time functions
The functions in this category enable you to analyze and work with date and time values in
formulas. For example, the TODAY function returns the current date (as stored in the system clock).
Math and trig functions
This category contains a wide variety of functions that perform mathematical and trigonometric
The trigonometric functions all assume radians for angles (not degrees). Use the
RADIANS function to convert degrees to radians.
The functions in this category perform statistical analysis on ranges of data. For example, you can
calculate statistics such as mean, mode, standard deviation, and variance. Excel 2010 includes
many new functions in this category.
Lookup and reference functions
Functions in this category are used to find (look up) values in lists or tables. A common example
is a tax table. You can use the VLOOKUP function to determine a tax rate for a particular income
Functions in this category are useful when you need to summarize data in a list (also known as a
worksheet database) that meets specific criteria. For example, assume you have a list that
contains monthly sales information. You can use the DCOUNT function to count the number of
records that describe sales in the Northern region with a value greater than 10,000.