Chapter 12. Building Formulas
FORMULAS are the heart and soul of a spreadsheet, and Microsoft Excel 2010 offers a rich environment in which to build complex formulas. Armed with a few mathematical operators and rules for cell entry, you can turn a worksheet into a powerful calculator. In this chapter, we cover the basics and then look more closely at using functions, defining names, building structured references, working with arrays, creating linking formulas, and constructing conditional tests.
Get Microsoft® Excel® 2010 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.
