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:

{={1,2,3,4;5,6,7,8;9,10,11,12}*{1,2,3,4;5,6,7,8;9,10,11,12}}

The following array formula is a simpler way of obtaining the same result:

{={1,2,3,4;5,6,7,8;9,10,11,12}^2}

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,

as follows:

{=A1:D3^2}

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.