Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Re-post Formula
Start date March 23, 2006 (Cell K3)
July to June (D7:O7) I have result D8+D9-10 (In D11) and I dragged this formula across to O11. I want a formula that will over ride the month of march only L11 (with is under the month of March) to be = 1or less than 1(=<1). This should be in reference to Month in K3. See example below. March as 3 and I need it to be 1 or less to go forward to april even if they are not used. ( it should be reference to March start month in K3 july aug sept oct nov dec jan feb mar apr may june (D7:O7) start bal. 1 2 0 0 0 2 2 2 2 1 0 0 (D8:O8) earned 1 0 0 0 2 0 0 0 1 0 0 0 (D9:O9) used 0 2 0 0 0 0 0 0 0 0 0 0 (D10:O10) Balance 2 0 0 0 2 2 2 2 3 (D11:O11) -- KK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Re-post Formula
Hi Kay,
in D7 enter If(o7=K3,1,(D8+D9-D10)) in e7 enter this formula If(D7=K3,1,(E8+e9-e10)) copy the formula to the end "Kay" wrote: Start date March 23, 2006 (Cell K3) July to June (D7:O7) I have result D8+D9-10 (In D11) and I dragged this formula across to O11. I want a formula that will over ride the month of march only L11 (with is under the month of March) to be = 1or less than 1(=<1). This should be in reference to Month in K3. See example below. March as 3 and I need it to be 1 or less to go forward to april even if they are not used. ( it should be reference to March start month in K3 july aug sept oct nov dec jan feb mar apr may june (D7:O7) start bal. 1 2 0 0 0 2 2 2 2 1 0 0 (D8:O8) earned 1 0 0 0 2 0 0 0 1 0 0 0 (D9:O9) used 0 2 0 0 0 0 0 0 0 0 0 0 (D10:O10) Balance 2 0 0 0 2 2 2 2 3 (D11:O11) -- KK |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Re-post Formula
The e-mail response to posting wasn't working from Wednesday to a few minutes
ago. There are response to all your questions. This is one of my responses to your previouw question You can create a date using the month in Row 2. for example =DateValue("January 1, 2009") =DateValue(A2&" 1, "&year(now()) Now you can compare the month in A1 with the month in the above formula if(month(A1)=DateValue(A2&" 1, "&year(now()),True,false) "Eduardo" wrote: Hi Kay, in D7 enter If(o7=K3,1,(D8+D9-D10)) in e7 enter this formula If(D7=K3,1,(E8+e9-e10)) copy the formula to the end "Kay" wrote: Start date March 23, 2006 (Cell K3) July to June (D7:O7) I have result D8+D9-10 (In D11) and I dragged this formula across to O11. I want a formula that will over ride the month of march only L11 (with is under the month of March) to be = 1or less than 1(=<1). This should be in reference to Month in K3. See example below. March as 3 and I need it to be 1 or less to go forward to april even if they are not used. ( it should be reference to March start month in K3 july aug sept oct nov dec jan feb mar apr may june (D7:O7) start bal. 1 2 0 0 0 2 2 2 2 1 0 0 (D8:O8) earned 1 0 0 0 2 0 0 0 1 0 0 0 (D9:O9) used 0 2 0 0 0 0 0 0 0 0 0 0 (D10:O10) Balance 2 0 0 0 2 2 2 2 3 (D11:O11) -- KK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPYING FORMULA CONTAINING NAMES... ( 2ND POST) | Excel Worksheet Functions | |||
COPYING FORMULA CONTAINING NAMES... ( 2ND POST) | Excel Discussion (Misc queries) | |||
Re-post VBA into Formula | Excel Worksheet Functions | |||
Formula Help - Not Sure Where to Post | Excel Discussion (Misc queries) | |||
Formula to post data in another spreadsheet | Excel Worksheet Functions |