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 all-important topic of operator precedence, copying and moving worksheet ...

Get Formulas and Functions with Microsoft® Excel 2003 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.