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