Posted to microsoft.public.excel.worksheet.functions

Rookie

external usenet poster

Posts: 19

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,"")))))))

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sum sub levels.	Jerome	Excel Discussion (Misc queries)	5	April 2nd 06 03:24 AM
sum sub levels.	Jerome	Excel Worksheet Functions	3	April 1st 06 05:03 AM
sum sub levels.	Jerome	New Users to Excel	0	March 30th 06 03:36 PM
Levels in Subtotals	KipNowlin	Excel Worksheet Functions	6	July 14th 05 07:03 AM
VLOOKUP with more than 7 levels of IF	AppraiserRon	Excel Worksheet Functions	6	May 26th 05 09:15 PM

All times are GMT +1. The time now is 01:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us