Hi Atis
It won't work this way. Though you created the matrix "numbers", in using it in the formulas you always get hold of the first item. You will need INDEX() to address the correct item.
That means that
=INDEX(numbers,1)*2
multiplies the first item of the matrix.
Usually you want some dynamic in the formula, that way you don't have to modify the formula over and over again. In the following it's done by using COLUMN():
Form1 = INDEX(numbers,COLUMN())*2
Form2 = INDEX(numbers,COLUMN())*10
That way it works when you use the formulas beginning in the first column.
Any questions?
|