The AreaSect() Function
Many functions have optional arguments. However, many of these optional arguments shouldn’t be ignored. These optional arguments have a specific value, and different values need to be used only in special cases. Therefore, default values are assigned to these optional arguments, and you need to make sure that if you do not specify a value for the optional argument, the default provided is appropriate. For this reason, the AreaSect() example in this section demonstrates the following:
How to use default values for missing optional arguments
How to evaluate conditions by using If statements
For example, the financial PMT() function calculates annuities and has five arguments. The last two of these arguments are optional: the ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
