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.

Note

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

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

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