finding extended cost from multiple bid prices

I am trying to pick up the most recent bid price and multiply it to the fixed 'estimated volume.

I recently had the code: if(E6<>””, C6*E6, C6*D6) -- but this is when I only had bid cost 1 and bid cost 2. Now I would like to add, bid price 3 and possible bid price 4. Any Ideas how I can do this?

Please see attachmentBook1.xlsx

Thank you all!

Wakefield101

Hi

I7: =D7*OFFSET(A7,0,MAX(IF(E7:H7<>0,COLUMN(E7:H7),""))-1) This formula is array entered (ctrl, shift, enter).

Copy down as required.

HTH

rylo