How do I get ending figure in proper cell?

G

Guest

I need to set up a statement that returns a value for the following:

If cell D1=0, get number from C4. If C4 also =0, get number from B4. If B4 =
0, get number from A4 (this will always have a value).

Here's how my info is set up:

Column: A B C D
Row value: 2 0 0 3
6 0 0 0
1 0 0 0
3 0 0 0

We enter inventory figures and i have 3 columns per month. Row 4 has an
ending figure that will carry forward to be row one of the next time we take
inventory. Usually we only do an inventory once a month so there will be 2
columns of zeros between inventory dates. How do I write a statement to keep
looking for a figure?
 
G

Guest

=IF(D1=0,INDEX(A4:C4,MAX(COLUMN(A4:C4)*(A4:C4>0))),D1)

ctrl+shift+enter, not just enter
 

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

Timesheet formula problem 2
colating multi rows of data into single rows - no to pivot tables! 4
How do I put a blank value in a cell not using "" in a formula 2
How can you replace specific characters in a string ? 2
Need cells to show as zero or empty 3
array formulas using MIN MAX 3
Function help requested please 6
checking two different cells 1

Top