K
Kay
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)
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)