# 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 =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 =SUM(.
 Press F3 to display a list of named ranges.
 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.

Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291