August 2010
Intermediate to advanced
320 pages
6h 57m
English
Content preview from Using Microsoft® Excel® 2010
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
6. Using Functions
This chapter will show you methods for finding the right function. It also reviews some functions you may find useful for everyday use.
Excel offers more than 400 functions. These include logical functions, lookup functions, statistical functions, financial functions and more. This chapter shows you how to look up functions and reviews some functions helpful for everyday use.
Breaking Down a Function
A function is like a shortcut for using a long or complex formula. You’ve probably used the SUM function like this: =SUM(A1:A5). Without the function, you would have to enter =A1+A2+A3+A4+A5.
Normally, the syntax of a function is like this:
FunctionName(Argument1, Argument2, ...)
A function consists of the name used to call it. ...