Microsoft® Office Excel® 2007 Inside Out

Appendix C. Function Reference

This appendix lists all the worksheet functions available in Microsoft Office Excel 2007 in alphabetical order. We include a description, the function syntax, and a description of each argument. Arguments that appear in bold text are required; arguments that do not appear in bold text are optional.

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.

Function	Description
ABS	Returns the absolute value of a number and takes the form =ABS(number). If a number ...