Logic formula in excel is not compiling in VBA

[peter.perhach]

Can someone tell me what the syntax error is in this statement/ formula? The formula works fine in excel, but when I edit my macro and paste this formula, it won't compile.

ActiveCell.FormulaR1C1 = "=IF(N2<=29,"<30",IF(AND(N2>29,N2<61),"30-60",IF(AND(N2>=61,N2<=90),"61-90",IF(AND(N2>=91,N2<=180),">90",">180"))))"

And if you have a better way to write this nested IF statement, I'd like to know.

The use of this formula, is a cell has a number and I want the formula to respond with a comment " " , based on the range that the value falls into.

Thanks

 

[wigi]

Don't mix up R1C1 and A1 notation.

But this is a typical usage for the VLOOKUP function, whereby you create a small lookup table with 2 columns: lookup value in the first column, and comment in the second.

In VBA you would then use:

ActiveCell.Formula = "=VLOOKUP(...,...,...,...)"