|
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? |
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? |
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") |
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") |
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") |
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") |
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") |
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") |
If Month?
Thank You,
I was starting in May and not January. It makes sense to me now and is now working. Thanks again for your help and your time. Richard "Glenn" wrote: 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") |
| All times are GMT +1. The time now is 02:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com