I need to have 2 mores options (ie HVAC_4 & HVAC_5)I am aware that I am
limited to 256 characters and making the range names smaller may help,
however is there another way of doing this that may eliminate the limitation.
I may also be reached during working hours at my office e-mail:

Regards

Leslie



=IF(OR(X$9=(DATE(YEAR(Budget_year),MONTH(Budget_ye ar)+3,1)),X$9=(DATE(YEAR(Budget_year),MONTH(Budget _year)+6,1)),X$9=(DATE(YEAR(Budget_year),MONTH(Bud get_year)+9,1)),X$9=Budget_year)*AND(contract!$E12 ="Quarterly"),HVAC_1/4,IF(contract!$E12="monthly",HVAC_1/12,IF(AND(contract!$F12=X$9,contract!$E12="annual" ),HVAC_1,0)))+IF(OR(X$9=(DATE(YEAR(Budget_year),MO NTH(Budget_year)+3,1)),X$9=(DATE(YEAR(Budget_year) ,MONTH(Budget_year)+6,1)),X$9=(DATE(YEAR(Budget_ye ar),MONTH(Budget_year)+9,1)),X$9=Budget_year)*AND( contract!$E13="Quarterly"),HVAC_2/4,IF(contract!$E13="monthly",HVAC_2/12,IF(AND(contract!$F13=X$9,contract!$E13="annual" ),HVAC_2)))+IF(OR(X$9=(DATE(YEAR(Budget_year),MONT H(Budget_year)+3,1)),X$9=(DATE(YEAR(Budget_year),M ONTH(Budget_year)+6,1)),X$9=(DATE(YEAR(Budget_year ),MONTH(Budget_year)+9,1)),X$9=Budget_year)*AND(co ntract!$E14="Quarterly"),HVAC_3/4,IF(contract!$E14="monthly",HVAC_3/12,IF(AND(contract!$F14=X$9,contract!$E14="annual" ),HVAC_3)))