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

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

Excel formula that adjusts to new columns as entries made incells
 

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

On Feb 5, 11:42*pm, Newsgal wrote:
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 is0?

--
News Gal

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

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!

--
News Gal


" wrote:

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

On Feb 5, 11:42 pm, Newsgal wrote:
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 is0?

--
News Gal