Next, you provide the sales projection numbers in column B. Assume that January’s sales are projected to be $50,000, and that sales will increase by 3.5 percent in each of the subsequent months.

1. Move the cell pointer to B2 and type 50000, the projected sales for January.
2. 2. To enter a formula to calculate the projected sales for February, move to cell B3 and enter the following: =B2*103.5%. When you press Enter, the cell will display 51750. The formula returns the contents of cell B2, multiplied by 103.5%. In other words, February sales are projected to be 3.5% greater than January sales.
3. The projected sales for subsequent months will use a similar formula. But rather than retyping the formula for each cell in column B, once again take advantage of the AutoFill feature. Make sure that cell B3 is selected. Click the cell’s fill handle, drag down to cell B13, and release the mouse button.

At this point, your worksheet should resemble the one shown in Figure 12-10. Keep in mind that, except for cell B2, the values in column B are calculated with formulas. To demonstrate, try changing the projected sales value for the initial month, January (in cell B2). You’ll find that the formulas recalculate and return different values. But these formulas all depend on the initial value in cell B2.

FIGURE 12-10
Your worksheet, after creating the formulas.

• Sierra GameKing 8MM 220 Grain Boat Tail Spitzer 50/Box Boat Tail SpitzerBoat Tail Spitzer 8mm50 Per Box Product DescriptionGameKing bullets are designed for hunting at long range, where their...
• Walking Cart Mount for Skygolf Skycaddie iGolf & Golflogix GPS User Reviews Send this to a friend Walking Cart Mount for Skygolf Skycaddie iGolf & Golflogix GPS Manufacturer: Arkon Customer...
• Morning Star Cedarwood Incense (50 Sticks) User Reviews Send this to a friend Morning Star Cedarwood Incense (50 Sticks) Manufacturer: Nippon Kodo Customer Rating: List Price:...
• Stanley Ho Planning Six More Casino Projects Including on The Cotai Strip As Macau casino magnate, Stanley Ho, is to open his 19th casino on 1 February, named Ponte 16 and set...
• Excel How-to: The SUMIF Function The SUMIF function is an easy way to get a subtotal of specific data that meets a certain condition, without...