Microsoft Office Tutorials and References

In Depth Information

**Introduction**

Cell Reference Examples

A
function
performs predefined calculations using specific values, called arguments.

For example, the function SUM(B1:B10) returns the sum of cells B1 through B10. An

argument can be numbers, text, logical values such as TRUE or FALSE, arrays, error val-

ues such as #NA, or cell references. Arguments can also be constants, formulas, or other

functions, known as
nested functions
. A function starts with the equal sign (=), followed

by the function name, an opening parenthesis, the arguments for the function separated

by commas, and a closing parenthesis. For example, the function, AVERAGE(A1:A10,

B1:B10), returns a number with the average for the contents of cells A1 through A10 and

B1 through B10. As you type a function, a ToolTip appears with the structure and argu-

ments needed to complete the function. You can also use the Insert Function dialog box to

help you add a function to a formula.