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)

HELP

Sako 338

"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