Thread: Overcoming the restriction of 7 nested IFs in Excel XP. Is it possible?
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default Overcoming the restriction of 7 nested IFs in Excel XP. Is it pos
"Bob Phillips" wrote...
Better than mine, but we should have gone to

=CHOOSE(MONTH(B10),"X","Y","Z","XX","YY","ZZ","XX X","YYY","ZZZ",
"XXXX","YYYY","ZZZZ")

Why not

=REPT(CHAR(88+MOD(MONTH(B10)-1,3)),INT((MONTH(B10)+2)/3))

?

Reply With QuoteReply With Quote