Chapter 20

A *formula* is an equation that calculates a new value from existing values. In Chapter 15, you learned how to build simple formulas using numbers and cell references, and in Chapter 18, you expanded your skills by creating formulas that linked to cells from other worksheets and workbooks. In this chapter, you'll discover how to build more sophisticated formulas. You'll learn how to use arithmetic operators and parentheses to control how your formulas are evaluated, you'll explore techniques for replicating formulas, and you'll practice using range names to make your formulas more readable and easier to modify. In addition, you'll learn how to use Microsoft Excel's impressive collection of built-in functions for specialized tasks such as totaling columns, computing averages, and calculating the monthly payments for an auto loan. Using well-organized formulas and functions, you can evaluate business data in new ways, spot important trends, and plan your financial future.

Running Microsoft Office 2000

ISBN: 1572319585

EAN: 2147483647

EAN: 2147483647

Year: 2005

Pages: 228

Pages: 228

Authors: Michael Halvorson, Michael J. Young

- Article 348 Flexible Metal Conduit Type FMC
- Article 424: Fixed Electric Space Heating Equipment
- Notes to Tables
- Example No. D2(b) Optional Calculation for One-Family Dwelling, Air Conditioning Larger than Heating [See 220.82(A) and 220.82(C)]
- Example No. D5(b) Optional Calculation for Multifamily Dwelling Served at 208Y/120 Volts, Three Phase

flylib.com © 2008-2017.

If you may any questions please contact us: flylib@qtcs.net

If you may any questions please contact us: flylib@qtcs.net