A1

B1 B2

X1 Y1 Z1

X2 Y2 Z2

Xn Yn Zn

Where all of the above are cells, and A1 is set equal to B1 and B2 (via a formula in A1 cell).

How would it be possible to do the followings in an automated way:

. Copy or feed X1 value to B1 and Y1 value to B2

. A1's result value then copied or fed to Z1

. So on for X2,Y2,Z2 up to Xn,Yn,Zn

In other words, I have a large fault tree, i.e. an arborescence with a single value on top (call a top event probability, A1 in this case) and various basic events at the bottom (only B1 and B2 in this example). In between there are various AND and OR gates. I want to feed values (called failure rates) to the basic events at the bottom and collect the results at the top to put this into a table (Z1, Z2 ... Zn).

Your help is appreciated ! Note that it is important for the above structure to remain intact (i.e. I can't simply put a formula in Z1 using B1 & B2 as parameters, the fault tree is very large and can not be translated into an equation).

Silmara