I am trying to record a macro, with a very long if-sequence. and it just says
"weren't able to record". I tried writing it in the VB-window as well but it
doesn't work:

this is the formula:
=IF(B2="Tobias";IF(N20,97*I2;IF(M2-1;IF(M2<10;1;0);0);IF(N2<0,03*I2;IF(O1=0;IF(M2-1;IF(M2<10;1;0);1);0);IF(O2=0;IF(M2-1;IF(M2<10;1;0);0);0)));IF(O2=0;IF(M2-1;IF(M2<10;1;0);0);0))

I guess it is too long? How do I then write it in the VB-editor?

When I wrote it in the editor it once worked but then it didn't like the B2
etc as cell references. I was using:

Range("Q2").Select
ActiveCell.FormulaR1C1 = "=IF(B2=""Tobias...etc

Thanks for any help on this matter,
Tobias