Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i return to normal text from =PROPER(cell) | Excel Discussion (Misc queries) | |||
Ending a macro early conditionally on one cell being blank | Excel Discussion (Misc queries) | |||
Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
cell * figure | Excel Discussion (Misc queries) | |||
I cant seem to figure out how to use Proper in excel. The help op. | Excel Discussion (Misc queries) |