Check cells in row for last cell with data to use as multiplier?
 

Week 1 Week 2 Week 3 Week 4 Week 5
B5 C5 D5 E5 F5 G5
H5
$26,665 100.0% 91.1% 0 0 0 $24,292

We have a spreadsheet that gets updated with new data each week. This
new data needs to become the new multiplier in the formula.
So, in the example above, I need a formula that reviews cells C5-G5 and
finds the first cell with a number zero and uses it to multiply the value
in B5 and insert the result in H5. Any ideas?
--
News Gal