Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |