O'Reilly logo

Microsoft Excel 2013 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Using functions

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 Microsoft Excel has hundreds of these special functions. Some functions, such as SIN and FACT, are the equivalent of lengthy mathematical formulas 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 29.

Using ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required