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