Microsoft Excel 2013 Inside Out

Appendix C. Function reference

• Alphabetical list of Excel 2013 functions

THIS APPENDIX lists the worksheet functions available in Microsoft Excel 2013 in alphabetical order. We include a description of the function, the function syntax, and a description of each argument.

You must type all function arguments in the order shown, and you should not add any spaces between or within arguments. Although Excel now generally accepts spaces in functions for readability, when you use spaces within a text argument or a reference argument, you must still enclose the entire argument in quotation marks. Arguments displayed in bold are required, and those in regular type are optional.

Note

The underlying algorithms for the following functions were modified for ...