Appendix C. Function reference

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.


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

Get Microsoft Excel 2013 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.