formulas
 

Cell A1 have May 5, 2006(start date)
cell A2:L2 have month from January to december
In cell A3:L3 and A4:L4 I have numbers under each months
in cell A5:L5 I have the fomula =A3-A4 I do this across to L3-L4
The only problem I need a formula to Make E5 which is under the month of may
1 or less than 1(it cannot go over 1) the other cells can be flexible
This formula should be base one cell A1 Start date.


--
KK

formulas
 

Try this formula in A5:

=MIN(1,A3-A4)

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Kay" wrote:

Cell A1 have May 5, 2006(start date)
cell A2:L2 have month from January to december
In cell A3:L3 and A4:L4 I have numbers under each months
in cell A5:L5 I have the fomula =A3-A4 I do this across to L3-L4
The only problem I need a formula to Make E5 which is under the month of may
1 or less than 1(it cannot go over 1) the other cells can be flexible
This formula should be base one cell A1 Start date.


--
KK

formulas
 

I want a formula base on cell A1(start month)
this formula should only be under May in E5
--
KK


"JBeaucaire" wrote:

Try this formula in A5:

=MIN(1,A3-A4)

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Kay" wrote:

Cell A1 have May 5, 2006(start date)
cell A2:L2 have month from January to december
In cell A3:L3 and A4:L4 I have numbers under each months
in cell A5:L5 I have the fomula =A3-A4 I do this across to L3-L4
The only problem I need a formula to Make E5 which is under the month of may
1 or less than 1(it cannot go over 1) the other cells can be flexible
This formula should be base one cell A1 Start date.


--
KK

formulas
 

I want a formula base on cell A1(start month)
this formula should only be under May in E5

I'm guessing that what you mean by
"base on cell A1"
is
"the month of A1 determines which column cannot go over 1."

Maybe it would help to put this in A5 and extend it to L5:
=IF(MONTH($A$1)=COLUMN(), MIN(A3-A4,1), A3-A4)

formulas
 

That is correct; I need to sum each column then over ride that one month
which reference to A1
--
KK


"MyVeryOwnSelf" wrote:

I want a formula base on cell A1(start month)
this formula should only be under May in E5

I'm guessing that what you mean by
"base on cell A1"
is
"the month of A1 determines which column cannot go over 1."

Maybe it would help to put this in A5 and extend it to L5:
=IF(MONTH($A$1)=COLUMN(), MIN(A3-A4,1), A3-A4)

formulas
 

You can create a date using the Row two name. 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)







"Kay" wrote:

That is correct; I need to sum each column then over ride that one month
which reference to A1
--
KK


"MyVeryOwnSelf" wrote:

I want a formula base on cell A1(start month)
this formula should only be under May in E5

I'm guessing that what you mean by
"base on cell A1"
is
"the month of A1 determines which column cannot go over 1."

Maybe it would help to put this in A5 and extend it to L5:
=IF(MONTH($A$1)=COLUMN(), MIN(A3-A4,1), A3-A4)