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.
I would like to finish rest of months. This formula is necessary because we are on fiscal year instead of calendar year.