Microsoft Office Tutorials and References
In Depth Information
Single-cell array formulas
Figure 12-33 We used a two-dimensional array formula in B10:E14 to compute the rank of each
exam score. A similar one-dimensional array appears in F10:F14.
Single-cell array formulas
You can perform calculations on a vast collection of values within a single cell by using an
array formula that produces a single value as a result. For example, you can create a simple
single-cell array formula to multiply the values in a range of cells by the values in an
adjacent range, as shown in Figure 12-34.
Figure 12-34 To calculate total wages paid, we used a single-cell array formula in B2 to multiply
hours worked by wages due for each employee individually.
In the example shown in Figure 12-34, you must enter the formula as an array formula (by
pressing Ctrl+Shift+Enter); entering it as a regular formula results in a #VALUE error. Our
example shows a tiny worksheet, but an array formula like this can make fast work of giant
tables.
Search JabSto ::

Custom Search