Check cells in row for last cell with data to use as multiplier?

N

Newsgal

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula that adjusts to new columns as entries made in cells 2
If Functions For Dyanmic Drop List 1
formula help 3
Adding cells but leaving blank if not populated 2
Macro for checking data in a cell against another cell andcopying/pasting data 8
writing a value to a particular cell from function 3
How to simplify If / ElseIf statement 4
pasting content copied from nonadajacent cells 1

Top