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
0?
--
News Gal