Hello,
I am using a macro to enter a long if statement formula, and I just can't seem to make the "&_" work to continue to the next line within the formula.
My code is:
ActiveCell.FormulaR1C1 = "=IF(AND(RC[-2]>=0,RC[-2]<100),""GOVT"", IF(AND(RC[-2]>100,RC[-2]<250),""MTGE"", IF(AND(RC[-2]>250,RC[-2]<400),""MUNI"", IF(RC[-2]>400,""CORP""))))"
Any suggestions?
Thanks
I am using a macro to enter a long if statement formula, and I just can't seem to make the "&_" work to continue to the next line within the formula.
My code is:
ActiveCell.FormulaR1C1 = "=IF(AND(RC[-2]>=0,RC[-2]<100),""GOVT"", IF(AND(RC[-2]>100,RC[-2]<250),""MTGE"", IF(AND(RC[-2]>250,RC[-2]<400),""MUNI"", IF(RC[-2]>400,""CORP""))))"
Any suggestions?
Thanks