Unabe To Record

[DC]

A B C D G H
CLOSE OUT 3/15/04
OTHER 1/15/04
MARCH 6/16/04

I am trying to record the following formula in H using a
macro and receive UNABLE TO RECORD after typeing the
formula.

If this is not the correct newsgourp I am very sorry for
posting here.

Any help on UNABLE TO RECORD is greatly appreciated.

'=IF(OR(A5="CLOSE OUT",A5="IRREGULAR",A5="OTHER"),CHOOSE
(MATCH(G5,--(YEAR(G5)&{"-01-01","-01-15","-02-15","-03-
15","-04-15","-05-15","-06-15","-07-15","-08-15","-09-
15","-10-15","-11-15","-12-15","-12-
32"})),"JANUARY","FEBRUARY","MARCH","APRIL","MAY","JUNE","J
ULY","AUGUST","SEPTEMBER","OCTOBER","NOVEMBER","DECEMBER","
JANUARY"),"")

 

[DC]

255 characters, Sorry to bother everyone.

Thanks Anyway.

 

[Peo Sjoblom]

You can define names for parts of the formula,
for instance

OR(A5="CLOSE OUT",A5="IRREGULAR",A5="OTHER")

can be named to something and so on

 

[DC]

How do you do that?

-----Original Message-----
You can define names for parts of the formula,
for instance

OR(A5="CLOSE OUT",A5="IRREGULAR",A5="OTHER")

can be named to something and so on
--

Regards,

Peo Sjoblom





.

 

[Peo Sjoblom]

Here's an example avoiding the 7 nested function limit

http://www.cpearson.com/excel/nested.htm