O'Reilly logo

Microsoft Excel 2013 Inside Out by Mark Dodge and Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Building formulas

FORMULAS are the heart and soul of a spreadsheet, and Microsoft Excel 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.

Formula fundamentals

A lot of this section will seem elementary to experienced Excel users, but it is important information ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required