Array Formulas
To understand array formulas, take a look at the functionality of a standard single-value formula. A single-value formula generates a result from several operands. For example, the formula =A4*B4 generates the product of both cells (see Figure 3-15). Compare this with the array formula {=E4:E8*F4:F8}. This formula generates five results—in this case, the product of the cells to the left and right of the multiplication sign.
Figure 3-15. Comparing a single value formula and an array formula.
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
