| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW I PRINT MY PAGE,MADE IN EXCEL,WITH CELLS & COLUMS | New Users to Excel | |||
| Column automatically adjusts width to fit text entries | New Users to Excel | |||
| what made my columns change from a b c to 1 2 3 ? Rows are 1 2 3 a | Excel Discussion (Misc queries) | |||
| copying a formula, the reference adjusts, but the result does not | Excel Discussion (Misc queries) | |||
| formula to display dbaseIII columns/rows in Excel Cells | Excel Programming | |||
Threaded Mode
