How do I get ending figure in proper cell?
 

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?

How do I get ending figure in proper cell?
 

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

ctrl+shift+enter, not just enter


"amithere" wrote:

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?

How do I get ending figure in proper cell?
 

Thanks!

"Teethless mama" wrote:

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

ctrl+shift+enter, not just enter


"amithere" wrote:

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?

How do I get ending figure in proper cell?
 

You're welcome!


"amithere" wrote:

Thanks!

"Teethless mama" wrote:

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

ctrl+shift+enter, not just enter


"amithere" wrote:

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?

How do I get ending figure in proper cell?
 

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

Vaya con Dios,
Chuck, CABGx3


"amithere" wrote:

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?