Don't use IF(), but use the CHOOSE() function, as Roger suggested.
As you've already got a variable set to the month serial number you don't
need the MONTH() function which Roger mentioned, but can merely use the
formula
=CHOOSE(L4,choice1,choice2,choice3,.....choice12)
--
David Biddulph

"sako 338" wrote in message
...
I couldn't get the suggestions to work (dunce) what i have at the moment is
=IF(L4=1,HYPERLINK("c:\K9 Stats\Cowie Stats\2007\January\Running Tally Jan
07.xls"),IF(L4=2.........(each new (IF)goes up by one month.

I need to extend this to cover twelve months (therein lies the nesting
problem with the seven level limit)

"Roger Govier" wrote:

Hi

You could use
=CHOOSE(MONTH(your_date),choice1,choice2,choice3,. ....choice12)

--
Regards

Roger Govier

"sako 338" <sako wrote in message
...
I have used a combination of HYPERLINK and IF to open a particular file
depending on the month serial number of the computer. The problem is I
need
to able to set the formula for a twelve month period and IF only
allows seven
functions. Any and all suggestions gratefully accepted