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 Formulas and Functions (Office 2021 and Microsoft 365) 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.
