Insert IF statement into a column of cells

[steven426]

Hi:

I am trying to insert an IF statement into a column of cells, but I am not sure where to put the quotation marks... I am getting an "application defined or object defined" error when I run the code

here is what I have

Range(Cells(2, Agency), Cells(NUM_POS, Agency)).Formula = "=IF(OR(RC=Agncy CMO Other, RC=MBS 15yr,RC=MBS 20yr,RC=MBS 25yr,RC=MBS 30yr,RC=MBS 40yr), AGENCY, NO"


This formula will yield one of the following phrases : "CMO Other" , "MBS 15yr" "MBS 20 yr" etc...

Thanks...

 

[texasalynn]

I find it easier to manually type the formula into excel, then do a macro record. Select the cell with the formula, press F2 <enter>. Stop recording. Now you will have the syntax and can modify to work in your macro.