MULTI FIELD FORMULA

[Guglielmo91]

Hello there,

i need some help to solve this matrix:

i need to fill the cells in the following way (excel language):

B2 =B1*A2

C2=C1*A2

D2=D1*A2

.

.

.

THEN 

B3 =B1*A3

C3=C1*A3

D3=D1*A3

and so on in order to fill the entire matrix. I guess i need to use the multifield formula, but i dont know how..

many thanks for your help 

[Christina_H · Accepted solution]

You can't actually do this in a multi-field formula since you are also referencing values from a previous row.  Here's an option transposing the data so you can complete all calculations in a single column.

[PhilipMannering · Accepted solution]

This might also do the trick,