O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

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

What Is a Worksheet Function?

Imagine a function as a complete computing program that can perform certain calculations. Each function has a unique name, which usually starts with a short description of the arithmetic problem solved by the function. Functions perform complex mathematical, statistical, technical, or logical calculations; search for certain information; and manipulate text.

Functions are mostly used in formulas, although you can use them in names and macros. (Names are covered in Chapter 5, and macros are covered in Chapter 6.) Functions can be nested or used multiple times within formulas.

In Microsoft Office Excel 2003, a formula can include up to seven levels of nested functions. In Excel 2007 and Excel 2010, up to 64 levels are ...

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