␡
- Introduction
- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
This chapter is from the book
Simplifying a Formula with Ranges
You can simplify formulas by using ranges and range names. For example, if 12 cells on your worksheet contain monthly budget amounts, and you want to multiply each amount by 10%, you can insert one range address in a formula instead of inserting 12 different cell addresses, or you can insert a range name. Using a range name in a formula helps to identify what the formula does; the formula =TotalOrder*0.10, for example, is more meaningful than =SUM(F6:F19)*0.10.
Use a Range in a Formula
- Put your cursor where you would like the formula. Type an equal sign (=) followed by the start of a formula, such as =SUM(.
- Click the first cell of the range, and then drag to select the last cell in the range. Excel enters the range address for you.
- Complete the formula by entering a close parentheses, or another function, and then click the Enter button.
Use a Range Name in a Formula
- Put your cursor where you would like the formula. Type an equal sign (=) followed by the start of a formula, such as =SUM(.
- Press F3 to display a list of named ranges.
- You can also click the Use in Formula button on the Formulas tab, and then click Paste.
- Click the name of the range you want to insert.
- Click OK.
- Complete the formula by entering a close parentheses, or another function, and then click the Enter button.