Nesting

DStan · Mar 13th, 2002, 01:12 PM

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.

Mark W. · Mar 13th, 2002, 01:15 PM

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 ]

Mark O'Brien · Mar 13th, 2002, 01:17 PM

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

Dave Patton · Mar 13th, 2002, 01:55 PM

Create a table of 1-12 and months

use formula such as =LOOKUP(B2,rMonth)

or use Vlookup(b2,rMonth,2)

Mar 13th, 2002, 01:17 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I believe VLOOKUP is also a popular suggestion. (I only use VBA so don't slap this suggestion too hard) __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 01:12 PM	#1
DStan New Member Join Date: Mar 2002 Posts: 6	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.

Mar 13th, 2002, 01:15 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Mar 13th, 2002, 01:55 PM	#4
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	Create a table of 1-12 and months use formula such as =LOOKUP(B2,rMonth) or use Vlookup(b2,rMonth,2)