How do I get ending figure in proper cell?

[amithere]

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?

 

[Teethless mama]

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

ctrl+shift+enter, not just enter

 

[amithere]

Thanks!

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

ctrl+shift+enter, not just enter

 

[Teethless mama]

You're welcome!

Thanks!

 

[CLR]

=IF(D1<>0,D1,IF(C4<>0,C4,IF(B4<>0,B4,A4)))

Vaya con Dios,
Chuck, CABGx3