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

[Marcol]

Try this in D4

Please Login or Register  to view this content.

Drag/Fill Down

Note
You have empty strings in Column G, these will have to be cleaned before this will work

[keis386]

I got a couple of good values but in a couple of cells i get a a value error. If it has to go up in column G it doen's work

[Marcol]

As I said, you have null strings in Column G , these have to be cleaned out.

Put this in J4

Please Login or Register  to view this content.

Drag/Fill Down to say J40

Copy this and paste special > values to G4, delete J4:J40

All should now work.

[keis386]

This is a sample of my excel sheet normally there are formullas in column G and not just a value. How do I clean up the empty strings?

[Marcol]

And where is ?

This is a sample of my excel sheet ...

Your sample should accurately represent your actual workbook, formulae included.

[keis386]

It works i used column J for the calculation in D. Thanks