Part II: Working with Formulas and Functions
- Press F9 to convert the cell references to values.
- Press Ctrl+Shift+Enter to re-enter the array formula (which now uses an array
constant).
The array constant is as follows:
{1,"dog",3;4,5,"cat";7,False,9;"monkey",8,12}
Figure 18.9 shows how this looks in the Formula bar.
FIGURE 18.9
After you press F9, the Formula bar displays the array constant.
Performing operations on an array
So far, most of the examples in this chapter simply entered arrays into ranges. The follow-
ing array formula creates a rectangular array and multiplies each array element by 2:
{={1,2,3,4;5,6,7,8;9,10,11,12}*2}
Figure 18.10 shows the result when you enter this formula into a range.
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. Figure 18.11
shows the result when you enter this formula into a range:
{={1,2,3,4;5,6,7,8;9,10,11,12}^2}
If the array is stored in a range (such as B8:E10), the array formula returns the square of
each value in the range as follows:
{=B8:E10^2}
