Array Formulas

To enter an array formula you first highlight the necessary cell. Either a column or row.

Row/Col

B

C

D

E

F

7

8

9

10

11

12

13

14

15

The blue highlighted cells is a row array and the yellow one is column array.

Once you have highlight the array, leave it highlighted and go to the formula bar (usually at the top) click in the bar and enter the formula. When you are through, instead of pushing enter, press:

CTRL-SHIFT-ENTER

at the same time. You will notice that Excel puts {} around the formula and will not let you edit and individual cells in the array. The only way to change it is to highlight and change the formula the same way you entered it or delete all the cells in the array.

Example:

Row/Col

B

C

D

E

F

28

29

Formula in cell to the left

30

3.696811

{=BSOPM(14,17.5,4,0.3083,0.07)}

31

2.923027

{=BSOPM(14,17.5,4,0.3083,0.07)}

32

0.655609

{=BSOPM(14,17.5,4,0.3083,0.07)}

33

5.48172

{=BSOPM(14,17.5,4,0.3083,0.07)}

34

-0.344391

{=BSOPM(14,17.5,4,0.3083,0.07)}

35

0.042653

{=BSOPM(14,17.5,4,0.3083,0.07)}

36

10.30946

{=BSOPM(14,17.5,4,0.3083,0.07)}

37

-0.781021

{=BSOPM(14,17.5,4,0.3083,0.07)}

38

0.144814

{=BSOPM(14,17.5,4,0.3083,0.07)}

39

21.92688

{=BSOPM(14,17.5,4,0.3083,0.07)}

40

-30.97798

{=BSOPM(14,17.5,4,0.3083,0.07)}

41

42