Using VBA to create multiple IF forumla

[iainfitzy]

Hi,

I can get my VBA code to create a standard if statement - however cannot get it to create a multiple if statement:-

Currently I have -

Cells(k, "G").FormulaR1C1 = "=IF(RC5>RC6,""W"",IF(RC5=RC6,1,""L"")"

However I get a object defined error.

Any help much appreciated.

Thanks,

Iain

 

[Desu Nota from Columbus]

Hi,

I can get my VBA code to create a standard if statement - however cannot get it to create a multiple if statement:-

Currently I have -

Cells(k, "G").FormulaR1C1 = "=IF(RC5>RC6,""W"",IF(RC5=RC6,1,""L"")"

However I get a object defined error.

Any help much appreciated.

Thanks,

Iain

Missing an end parenthesis.

Cells(k, "G").FormulaR1C1 = "=IF(RC5>RC6,""W"",IF(RC5=RC6,1,""L""))"