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 ...