Chapter 4

Using Functions

Publisher Summary

Microsoft Excel 2007 provides over 300 worksheet functions, which are divided into 12 groups: Add-in and Automation, Cube, Database, Date and Time, Engineering, Financial, Information, Logical, Lookup and Reference, Math and Trigonometry, Statistical, and Text. Functions are always used as part of a formula as in =SIN(Al) or =8+LOG(Bl, 2). When a cell contains a formula, the formula bar displays that formula, but the cell generally displays the value produced by the formula. The phrase “the value returned by the formula is” often used for this quantity. The terms SIN and LOG are the names of the functions and the quantities Al, Bl, and 2 are called arguments. Arguments are contained within parentheses, ...

Get A Guide to Microsoft Excel 2007 for Scientists and Engineers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.