View Single Post
 
Old 05-28-2014, 04:33 PM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

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?
Reply With Quote