Alphabetical List of Selected Worksheet Functions

Returns the absolute value of a number Syntax ABS(number) 

Number must be from -1 to +1. The returned angle is in radians, in the range 0 to 71. To convert the result to degrees, multiply by ISO/tt. 

Syntax ADDRESS row num,column num,abs num,a1,sheet text) Abs num specifies the type of reference to return. If abs num is 1 or omitted, returns an absolute reference if 2, absolute row and relative column if 3, relative row and absolute column if 4, relative. A1 is a logical value that specifies the A1 or R1C1 reference style. If A1 is TRUE or omitted, ADDRESS returns an A1-style 

Returns TRUE if all arguments are TRUE, otherwise returns FALSE. 

Example If A1 contains 0 and A2 contains 110, then =AND(A1 =0,A2 100) returns TRUE. 

---

Appendix B Alphabetical List of Selected Worksheet Functions... 

Appendix A lists selected worksheet functions in the Database, Date Time, Information, Logical, Lookup Reference, Math Trig, Statistical, Lookup Reference, and Text categories. Appendix B provides an alphabetical list of these worksheet functions along with the required syntax, some comments on the required and optional arguments, one or more examples and a list of related functions. 

Excel 2000 provides more than 300 worksheet functions, in 11 categories Engineering, Financial, Date Time, Information, Math Trig, Statistical, Lookup Reference, Database, Text, Logical, External. This book uses functions from seven of those categories. This appendix lists selected worksheet functions by category. In Appendix B, the functions are listed alphabetically, with comments, examples and related functions. 

---