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 ...