Microsoft Office Tutorials and References
In Depth Information
Figure 14-10: Performing a mathematical operation on an array.
The following array formula multiplies each array element by itself:
The following array formula is a simpler way of obtaining the same result:
Figure 14-11 shows the result when you enter this formula into a range (B8:E10).
If the array is stored in a range (such as A1:D3), the array formula returns the square of each value in the range,
In some of these examples are brackets that you must enter to define an array constant
as well as brackets that Excel enters when you define an array by pressing
Ctrl+Shift+Enter. An easy way to tell whether you must enter the brackets is to note the
position of the opening curly bracket. If it's before the equal sign, Excel enters the
brackets. If it's after the equal sign, you enter them.