Formula too long - help needed!

[sadsfan]

Hi, I have written the formula, but Excel 2003 says it is too long, could anyone out there help me shorten it?

[FONT=Times New Roman][SIZE=3]=OR(AND(CG5=1,OR(AM5={19,21,23,25,27,29,31,33,35})),AND[/SIZE][/FONT]
[SIZE=3][FONT=Times New Roman](CG5=2,OR(AM5={25,27,29,31,33,35})),AND(CG5=3,OR(AM5=[/FONT][/SIZE]
[SIZE=3][FONT=Times New Roman]{31,33,35})),AND(CG5=1,OR(AS5={19,21,23,25,27,29,31,33,35})),AND
(CG5=2,OR(AS5={25,27,29,31,33,35})),AND(CG5=3,OR(AS5=
{31,33,35})),AND(CG5=1,OR(AV5={19,21,23,25,27,29,31,33,35})),AND
(CG5=2,OR(AV5={25,27,29,31,33,35})),AND(CG5=3,OR(AV5=
{31,33,35})),AND(CG5=1,OR(AY5={19,21,23,25,27,29,31,33,35})),AND
(CG5=2,OR(AY5={25,27,29,31,33,35})),AND(CG5=3,OR(AY5=
{31,33,35})),AND(CG5=1,OR(BE5={19,21,23,25,27,29,31,33,35})),AND
(CG5=2,OR(BE5={25,27,29,31,33,35})),AND(CG5=3,OR(BE5=
{31,33,35})),AND(CG5=1,OR(BH5={19,21,23,25,27,29,31,33,35})),AND
(CG5=2,OR(BH5={25,27,29,31,33,35})),AND(CG5=3,OR(BH5=
{31,33,35})),AND(CG5=1,OR(BK5={19,21,23,25,27,29,31,33,35})),AND
(CG5=2,OR(BK5={25,27,29,31,33,35})),AND(CG5=3,OR(BK5=
{31,33,35})),AND(CG5=1,OR(BQ5={19,21,23,25,27,29,31,33,35})),AND
(CG5=2,OR(BQ5={25,27,29,31,33,35})),AND(CG5=3,OR(BQ5=
{31,33,35})),AND(CG5=1,OR(BT5={19,21,23,25,27,29,31,33,35})),AND
(CG5=2,OR(BT5={25,27,29,31,33,35})),AND(CG5=3,OR(BT5=
{31,33,35})))[/FONT][/SIZE]

Hope that makes sense, I've pasted it as code, but it does go in the formula bar.

Thanks

 

[sadsfan]

Thank you all, I've got it working!

 

[Oaktree]

Oaktree, does that work in Excel 2007+?

The Morefunc functions would work... not sure about embedding. The official site is:

http://xcell05.free.fr/english/

which lists 2007 as a compatible version.

 

[T. Valko]

The Morefunc functions would work... not sure about embedding. The official site is:

http://xcell05.free.fr/english/

which lists 2007 as a compatible version.

There's no option to embed in Excel 2007.