Nesting
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Nesting

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there any way around the 7 level limit in nesting? My formula is =IF(D1=1,"JULY",IF(D1=2,"AUGUST",IF(D1=3,"SEPTEMBER",IF(D1=4,"OCTOBER",IF(D1=5,"NOVEMBER",IF(D1=6,"DECEMBER",IF(D1=7,"JANUARY",IF(D1=8,"FEBUARY",))))))))
    I would like to finish rest of months. This formula is necessary because we are on fiscal year instead of calendar year.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use the CHOOSE worksheet function...

    =CHOOSE(D1,"JULY","AUGUST","SEPTEMBER","OCTOBER","NOVEMBER","DECEMBER","JANUARY","FEBUARY","MARCH","APRIL","MAY","JUNE")

    [ This Message was edited by: Mark W. on 2002-03-13 12:59 ]

  3. #3
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I believe VLOOKUP is also a popular suggestion. (I only use VBA so don't slap this suggestion too hard)

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,329
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      


    Create a table of 1-12 and months

    use formula such as =LOOKUP(B2,rMonth)

    or use Vlookup(b2,rMonth,2)

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com