ExcelBanter - Re-post Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Re-post Formula (https://www.excelbanter.com/excel-worksheet-functions/231994-re-post-formula.html)

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

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

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