Financial Analysis and Modeling Using Excel and VBA

Appendix C. Excel and VBA Built-In Functions

This appendix contains categorized selected lists of the built-in functions available for use in Excel (worksheets) and VBA along with a brief description for each. I have used the same categories as are used by Excel in the Insert Function (Paste Function in the earlier versions of Excel) dialog box to make it easy to find a function you are looking for. Each category includes both the available worksheet and VBA functions, and the scope of each function (discussed below) indicates where and how you can use it.

These are selected rather than exhaustive lists. To avoid clutter, in each category I have selectively included only the functions you are likely to find useful in financial modeling and analysis. I have completely omitted the Engineering, Database, and TrigoNametric functions because you will rarely use them.

For brevity, the description of each function includes only the information needed to quickly decide if a particular function may be useful for a particular model or analysis. If you are not familiar with the function, you will have to look up its description in the relevant chapter in Part One or in Excel's Help.

Scope of a Function

Scope of a Function

For worksheet functions that have equivalent VBA forms, you must use the VBA form in VBA. These are identified with a # next to them. You can use the other worksheet functions in VBA, but you have to precede the worksheet function name by Application or WorksheetFunction followed ...