Thread: How to add more than 7 if nested statements. 7 is the limit.
View Single Post
  #1   Report Post  
RRS from Connecticut
 
Posts: n/a
Default How to add more than 7 if nested statements. 7 is the limit.
I am trying to show 12 month names from dates, but can show only 8 since if
statments can be nested 7 times.
Eg of my data and formula:
=IF(MONTH(D2)=10,"Oct04",IF(MONTH(D2)=11,"Nov04",I F(MONTH(D2)=1,"Jan05",IF(MONTH(D2)=2,"Feb05",IF(MO NTH(D2)=3,"Mar05",IF(MONTH(D2)=12,"Dec04",IF(MONTH (D2)=4,"Apr05")))))))
I need to join the if statment to show the rest of the months.
Thanks.
RRS.
Reply With QuoteReply With Quote