Hello,



I need a kind of "matrix of formula's". I'd like to handle the following with excel 2007 : on the first line, I have

1 2 3 4.

I named this cells "numbers".

Now, I have 2 formulas which I named "form1" and "form2", for example "form1" is "numbers*2" and "form2" is "numbers*10".

I would like "form1" apply to the first and third cells of "numbers", and "form2" to the second and fourth cells of "numbers". But if I enter on the second line

=form1 =form2 =form1 =form2

I get

2 20 2 20

instead of

2 20 6 40

Can someone help me ?

Atis

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?

Hello,

Thanks for your answer. But it's not really what I'm looking for. I need more a matrix formula.

Like this : if you have

2 4

on the first line, and you type "=form1" validated with ctrl+shift+enter, you get

2 4

I'm looking for something similar but with two forumula's, like {=form1;=form2}

Atis

Please post a sample sheet ( no pics please) showing what you have and the expected resukt - Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post