Nesting

[DStan]

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.]

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]

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

 

[Dave Patton]

Create a table of 1-12 and months

use formula such as =LOOKUP(B2,rMonth)

or use Vlookup(b2,rMonth,2)