| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Month?
I am struggling with an If=Month formula. In its simplest form, A1:A12 is
January thru December. Cell C1 to show "If month (happens to be May of course) than show "May". Next month the same cell (C1) will say June, and so on. Can't believe I'm struggling to get this to work? Can you help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Month?
=TEXT(TODAY(),"mmm")
-- If this post helps click Yes --------------- Jacob Skaria "RJJ" wrote: I am struggling with an If=Month formula. In its simplest form, A1:A12 is January thru December. Cell C1 to show "If month (happens to be May of course) than show "May". Next month the same cell (C1) will say June, and so on. Can't believe I'm struggling to get this to work? Can you help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Month?
RJJ wrote:
I am struggling with an If=Month formula. In its simplest form, A1:A12 is January thru December. Cell C1 to show "If month (happens to be May of course) than show "May". Next month the same cell (C1) will say June, and so on. Can't believe I'm struggling to get this to work? Can you help? =TEXT(TODAY(),"mmmm") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Month?
OK, but how do I include an IF statement? In other words (Apply to cell M4),
If actual month is January, M4 displays the value of R14, If actual month is February, M4 displays the value of U14, if actual month is March, M4 displays the value of X14, and so on for the 12 months and each month having the same destination of M4, but one of twelve differnt source possiblities "Glenn" wrote: RJJ wrote: I am struggling with an If=Month formula. In its simplest form, A1:A12 is January thru December. Cell C1 to show "If month (happens to be May of course) than show "May". Next month the same cell (C1) will say June, and so on. Can't believe I'm struggling to get this to work? Can you help? =TEXT(TODAY(),"mmmm") |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Month?
=CHOOSE(MONTH(TODAY()),R14,U14,X14...
RJJ wrote: OK, but how do I include an IF statement? In other words (Apply to cell M4), If actual month is January, M4 displays the value of R14, If actual month is February, M4 displays the value of U14, if actual month is March, M4 displays the value of X14, and so on for the 12 months and each month having the same destination of M4, but one of twelve differnt source possiblities "Glenn" wrote: RJJ wrote: I am struggling with an If=Month formula. In its simplest form, A1:A12 is January thru December. Cell C1 to show "If month (happens to be May of course) than show "May". Next month the same cell (C1) will say June, and so on. Can't believe I'm struggling to get this to work? Can you help? =TEXT(TODAY(),"mmmm") |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Month?
OK, I tried:
=CHOOSE(MONTH(TODAY()),U108,AB108,AI108,AP108,AW10 8,BD108,BK108,BR108) Did not give any error but the value (name) residing in U108 does not appear in the cell I placed this formula. Also, do I need the TODAY() argument when I am only looking at the month? Richard "Glenn" wrote: =CHOOSE(MONTH(TODAY()),R14,U14,X14... RJJ wrote: OK, but how do I include an IF statement? In other words (Apply to cell M4), If actual month is January, M4 displays the value of R14, If actual month is February, M4 displays the value of U14, if actual month is March, M4 displays the value of X14, and so on for the 12 months and each month having the same destination of M4, but one of twelve differnt source possiblities "Glenn" wrote: RJJ wrote: I am struggling with an If=Month formula. In its simplest form, A1:A12 is January thru December. Cell C1 to show "If month (happens to be May of course) than show "May". Next month the same cell (C1) will say June, and so on. Can't believe I'm struggling to get this to work? Can you help? =TEXT(TODAY(),"mmmm") |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Month?
MONTH(TODAY()) is going to return a number from 1 to 12, depending upon the
current month. Right now, your formula below should return the value in AW108 because May is the 5th month and AW108 is the 5th value listed in your formula. If you actually want to make this choice based upon a date in a cell, put that cell reference in the formula in place of "TODAY()". Also, you likely should have 12 values in the CHOOSE() function, one for each month. RJJ wrote: OK, I tried: =CHOOSE(MONTH(TODAY()),U108,AB108,AI108,AP108,AW10 8,BD108,BK108,BR108) Did not give any error but the value (name) residing in U108 does not appear in the cell I placed this formula. Also, do I need the TODAY() argument when I am only looking at the month? Richard "Glenn" wrote: =CHOOSE(MONTH(TODAY()),R14,U14,X14... RJJ wrote: OK, but how do I include an IF statement? In other words (Apply to cell M4), If actual month is January, M4 displays the value of R14, If actual month is February, M4 displays the value of U14, if actual month is March, M4 displays the value of X14, and so on for the 12 months and each month having the same destination of M4, but one of twelve differnt source possiblities "Glenn" wrote: RJJ wrote: I am struggling with an If=Month formula. In its simplest form, A1:A12 is January thru December. Cell C1 to show "If month (happens to be May of course) than show "May". Next month the same cell (C1) will say June, and so on. Can't believe I'm struggling to get this to work? Can you help? =TEXT(TODAY(),"mmmm") |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Month?
Try this:
=OFFSET(R14,,MONTH(TODAY())*3-3) "RJJ" wrote: OK, but how do I include an IF statement? In other words (Apply to cell M4), If actual month is January, M4 displays the value of R14, If actual month is February, M4 displays the value of U14, if actual month is March, M4 displays the value of X14, and so on for the 12 months and each month having the same destination of M4, but one of twelve differnt source possiblities "Glenn" wrote: RJJ wrote: I am struggling with an If=Month formula. In its simplest form, A1:A12 is January thru December. Cell C1 to show "If month (happens to be May of course) than show "May". Next month the same cell (C1) will say June, and so on. Can't believe I'm struggling to get this to work? Can you help? =TEXT(TODAY(),"mmmm") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
| Create Month Timetable on a worksheet different month each works | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Hybrid Mode
