Microsoft Office Tutorials and References

In Depth Information

amount. This formula uses the IF function to check the value in cell A1 and make the appropriate commission

calculation:

=IF(A1<100000,A1*5%,A1*7.5%)

The IF function takes three arguments, each separated by a comma. These arguments provide input to the func-

tion. The formula is making a decision: If the value in cell A1 is less than 100,000, then return the value in cell

A1 multiplied by 5 percent. Otherwise, return the value in cell A1 multiplied by 7.5 percent.

More about functions

All told, Excel 2013 includes more than 450 functions. And if that's not enough, you can purchase additional

specialized functions from third-party suppliers, and you can even create your own custom functions (using

VBA).

If you're ready to create your own custom functions by using VBA, check out Part VI of

this book.

The sheer number of available worksheet functions may overwhelm you, but you'll probably find that you use

only a dozen or so of the functions on a regular basis. And as you'll see, the Function Library group on the For-

mulas tab (described later in this chapter) makes it easy to locate and insert a function, even if you use it only

rarely.

Appendix A contains a complete listing of Excel's worksheet functions, with a brief de-

scription of each.

Function Argument Types

If you examine the preceding examples in this chapter, you'll notice that all the functions use a set of paren-

theses. The information within the parentheses is the function's
arguments.
Functions vary in how they use ar-

guments. A function may use

• No arguments

• A fixed number of arguments

• An indeterminate number of arguments

• Optional arguments