Unabe To Record

D

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"),"")
 
P

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
 
D

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





.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top