Page 340 - Excel 2013 All-in-One For Dummies
P. 340
322 Adding Array Formulas
When entering an array formula, you must remember to press Ctrl+Shift+Enter instead of just the Enter key because this special key combination tells Excel that you are building an array formula, so that the program encloses the for- mula in braces and copies it to every cell in the array range. Also, don’t try to create an array formula by editing it on the Formula bar and then insert curly braces because this doesn’t cut it. The only way to create an array formula is by pressing Ctrl+Shift+Enter to complete the formula entry.
Figure 1-11 shows you the February wage table after completing all the array formulas in three ranges: R10:R13, AI10:AI13, and AJ10:AJ13. In the second cell range, AI10:AI13, I entered the following array formula to calculate the hourly wages for the second pay period in February:
{=A4:A7*AI4:AI7}
In the third cell range, AJ10:AJ13, I entered the following array formula to calculate the total wages paid to each employee in February 2003:
{=R10:R13+AI10:AI13}
Figure 1-11:
The hourly wage spreadsheet after entering all three array formulas.
