| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check data from different cells | Excel Worksheet Functions | |||
| check certain cells for data before saving file | Excel Worksheet Functions | |||
| when i use =product(cell,multiplier), the box ... only shows ### | Excel Discussion (Misc queries) | |||
| updating a range of cells by a multiplier | Excel Worksheet Functions | |||
| Check if filtered cells contain data to delete | Excel Programming | |||
Hybrid Mode
