Microsoft Office Tutorials and References
In Depth Information
Using Arrays in Formulas
However, getting the braces into the formula takes a particular keystroke.
You don’t type braces in directly.
Using Arrays in Formulas
You can use arrays when entering formulas and functions. Typically, the
arguments to a function are entered in a different manner, which I
demonstrate in this section. Using arrays can save entry steps and deliver an
answer in a single formula. This is useful in situations that normally require
a set of intermediate calculations from which the final result is calculated. I
don’t know about you, but I like shortcuts, especially when I have too much
to do!
Here’s an example: The SUM function is normally used to add a few numbers
together. Summing up a few numbers doesn’t require an array formula per
se, but what about summing up the results of other calculations? This next
example shows how using an array simplifies getting to the final result.
Figure 3-2 shows a small portfolio of stocks. Column A has the stock symbols,
Column B has the number of shares per stock, and Column C has a recent
price for each stock.
Figure 3-2:
A stock
portfolio.
The task is to find out the total value of the portfolio. The typical way to do
this is to
1. Multiply the number of shares for each stock by its price.
2. Sum up the results from Step 1.
Search JabSto ::




Custom Search