Thread: Overcoming the restriction of 7 nested IFs in Excel XP. Is it possible?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd Bernd is offline
external usenet poster
  
Posts: 92
Default Overcoming the restriction of 7 nested IFs in Excel XP. Is it possible?
Or

=MID("XXXXYYYYZZZZ",1+4*(MOD(MONTH(A1)-1,3)),(MONTH(A1)+2)/3)

Regards,
Bernd

Reply With QuoteReply With Quote