sign value reference to value in column

[keis386]

Dear sir/madam,

I have a small question, If a sign value in column E say 0 or 1 I have to take over the last value in column G.

If there is a 1 in column E, you follow the row to column G and go up to find the first cell with a value. Then you calculate b1*value of cell column G.
If there is a 0 in column E, you follow the row to column G and go up to find the first cell with a value. Then you calculate d1*value of cell column G.

In the excel file you can see what I mean, I think it is not hard, but I can't get it working.

Thanks