Microsoft Office Tutorials and References
In Depth Information
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.