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 formulas, and making formulas easier to build and read by taking advantage of range names.
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 that perform calculations and produce results.
Each group has its own set of operators, and you use each group in different ways.
In the next few sections, I show you how to use each type of formula. They combine numbers, cell addresses, and function results with mathematical operators to perform calculations.
On the Data tab, in the Connections group, click the Edit links symbol to launch the Edit Links dialog box. If you didn't update the links, you can still update the links here. If you don't want to display the alert and update the links automatically, Click Startup Prompt, select the third option, and click OK.