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
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 for the remaining examples.
3.12.136.119