Chapter 1

Building basic formulas

In this chapter, you will:

  • Learn the basics of building formulas in Excel.

  • Understand operator precedence and how it affects your formula results.

  • Learn how to control worksheet calculations.

  • Learn how to copy and move formulas.

  • Learn how to work with range names in formulas.

  • Build formulas that contain links to cells or ranges in other worksheets and workbooks.

A worksheet is merely a lifeless collection of numbers and text until you define a relationship among the various entries. You do this by creating formulas that perform calculations and produce results. This chapter takes you through some formula basics, including constructing simple arithmetic and text formulas, understanding the all-important topic ...

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.