Page 339 - Excel 2013 All-in-One For Dummies

Adding Array Formulas 321
1. Make cell R10 the current cell, and then select the array range
R10:R13 and type = (equal sign) to start the array formula.
You always start an array formula by selecting the cell or cell range where the results are to appear. Note that array formulas, like standard formulas, begin with the equal sign.
2. Select the range A4:A7 that contains the hourly rate for each employee as shown, type an * (asterisk for multiplication), and then select the range R4:R7 that contains the total number of hours worked during the first pay period.
3. Press Ctrl+Shift+Enter to insert an array formula in the array range.
When you press Ctrl+Shift+Enter to complete the formula, Excel inserts braces around the formula and copies the array formula {=A4:A7*R4:R7} into each of the cells in the array range R10:R13.
Figure 1-10:
Building
an array formula to calculate hourly wages for the first pay period.
Book III Chapter 1
Building Basic Formulas