Data Validation custom formula length restriction?

[lovemy65stang]

I am quite familiar with data validation, and writing custom data validation formulas. I am having a frustrating problem though and can't seem to figure out a way around it. I'm trying to enter the following custom data validation formula into cell F17, but it appears that the formula is too long to be entered:

=IF(ISBLANK(D17),F17="",AND(ISNUMBER(F17),OR(AND(ISNUMBER(B20),ISNUMBER(B21),F17+(G17/12)+(I17/12*0.5)<=B20,F17+(G17/12)-(I17/12*0.5)>=B21),AND(ISNUMBER(B39),ISNUMBER(B40),F17+(G17/12)+(I17/12*0.5)<=B39,F17+(G17/12)-(I17/12*0.5)>=B40),AND(ISNUMBER(B58),ISNUMBER(B59),F17+(G17/12)+(I17/12*0.5)<=B58,F17+(G17/12)-(I17/12*0.5)>=B59),AND(ISNUMBER(B77),ISNUMBER(B78),F17+(G17/12)+(I17/12*0.5)<=B77,F17+(G17/12)-(I17/12*0.5)>=B78),AND(ISNUMBER(B96),ISNUMBER(B97),F17+(G17/12)+(I17/12*0.5)<=B96,F17+(G17/12)-(I17/12*0.5)>=B97))))

I'm using Excel 2000 at my workplace. Do newer versions of Excel allow for longer formulas? Is there a way to make the formula shorter, but still function the same? I'm stumped Any help would be greatly appreciated!
-Brian

 

[Fluff]

Please start a new thread for your question. You are more likely to get help that way.
Thanks