Chapter 18: Understanding and Using Array Formulas
18
FIGURE 18.10
Performing a mathematical operation on an array
FIGURE 18.11
Multiplying each array element by itself
Using functions with an array
As you may expect, you can also use worksheet functions with an array. The following
array formula, which you can enter into a ten-cell vertical range, calculates the square root
of each array element in the array constant:
{=SQRT({1;2;3;4;5;6;7;8;9;10})}If the array is stored in a range, a multicell array formula such as the one that follows
returns the square root of each value in the range:
{=SQRT(A1:A10)}