Excel formula that adjusts to new columns as entries made in cells

[Newsgal]

I have a spreadsheet where the multiplier cell changes each week, but the
previous week(s) data still must be viewed. This then requires cells in 5
different columns to each be used as the multiplier in the formula at one
time during the month. For example:
Week 1 = C5*D5, Week 2 = C5*E5, Week 3 = C5*F5, etc.
How can I build a formula that finds the next cell with a content value of
zero and selects the previous cell as the new multiplier if it's content is

 

[paul.robinson]

Hi
Not clear to me how your last paragraph relates to your first one. In
your last paragraph what do you mean by "next cell" - next one up,
next one to left, next one in some other sense? Can you give a small
example of some data and what you want your formula to output.
regards
Paul

 

[Newsgal]

The "next" cell is the cell to the right. For example:
Week 1 = data in cell D5 is the multiplier. Weeks 2-5 all have a zero value.
Week 2 = data in cell E5 is the multiplier. Weeks 3-5 all have a zero value.
So the formula has to ignore Week 1 data and pickup Week 2 data.
Week 3 = data in cell F5 is the multiplier. Weeks 4-5 have a zero value. So
the formula has to ignore Week 1 AND Week 2 data and pickup Week 3 data.
Etc.
Hope this clarifies it.
Thanks!