• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Chapter 3. Building Basic Formulas

IN THIS CHAPTER

Understanding Formula Basics

Understanding Operator Precedence

Controlling Worksheet Calculation

Copying and Moving Formulas

Displaying Worksheet Formulas

Converting a Formula to a Value

Working with Range Names in Formulas

Working with Links in Formulas

Formatting Numbers, Dates, and Times

A worksheet is merely a lifeless collection of numbers and text until you define some kind of 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 allimportant topic of operator precedence, copying and moving worksheet formulas, and making formulas easier to build and read by taking advantage of range names.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint