• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Chapter 13. Using Functions

Using Excel's Built-In Function Reference 401

Installing the Analysis ToolPak 403

Exploring the Syntax of Functions 404

Inserting Functions 406

Worksheet functions are special tools that perform complex calculations quickly and easily. They work like the special keys on sophisticated calculators that compute square roots, logarithms, and statistical evaluations—except that Microsoft Excel has hundreds of these special functions. Some functions, such as SIN and FACT, are the equivalent of lengthy mathematical formulas that you would otherwise have to create by hand. Other functions, such as IF and VLOOKUP, can't be otherwise duplicated by formulas. When none of the built-in functions is quite what you need, you can create custom functions, as explained in Chapter 32, “Creating Custom Functions.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint