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
Search JabSto ::




Custom Search