Re-post Formula

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)
 
E

Eduardo

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
 
J

Joel

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top