Chapter 5. Functions in Special Operations
This chapter explains the use of worksheet functions and in particular how to integrate them with other features of Microsoft Excel to provide a very powerful tool with endless possibilities.
You will find out what role the functions can play together with:
Names
Conditional formatting
Validation
Note
In this chapter, an effort is made to provide descriptions for the Excel versions up to Microsoft Office Excel 2003, as well as for Excel 2007 and Excel 2010, when the user interface changed dramatically. The first examples contain both commands and approaches that should provide enough information for you to assume the correct approach ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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.