Microsoft Office Tutorials and References
In Depth Information
Figure 14-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 following array formula cre-
ates a rectangular array and multiplies each array element by 2:
{={1,2,3,4;5,6,7,8;9,10,11,12}*2}
Figure 14-10 shows the result when you enter this formula into a range:
Search JabSto ::




Custom Search