View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rookie Rookie is offline
external usenet poster
 
Posts: 19
Default too many levels of nesting

I know that I am exceeding my nesting levels. But can anyone provide a fomula
that would help me make all 12 months work? Here is the first 6 months
formula that I have:

=IF(MONTH(B4)=1,'Jan Draws'!G4,IF(MONTH(B4)=2,'Feb
Draws'!G4,IF(MONTH(B4)=3,'Mar Draws'!G4,IF(MONTH(B4)=4,'April
Draws'!G4,IF(MONTH(B4)=5,'May Draws'!G4,IF(MONTH(B4)=6,'June
Draws'!G4,IF(MONTH(B4)=7,'July Draws'!G4,"")))))))