Microsoft® Excel® 2010 Inside Out

Appendix C. Function Reference

THIS appendix lists the worksheet functions available in Microsoft Excel 2010 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. While 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 have been modified for increased accuracy in Excel 2010, with ...