VBA R1C1 formatting question

[stlpony]

Hello!

I'm trying to enter an if statement within VBA ...

ActiveCell.FormulaR1C1 = _
"=IFERROR(IF((OR(RC[-1]=""Active Client - TOA"",OR(RC[-1]=""Past Client"")),""Yes"",""No""),""No"")"

If the cell to the left is either "Active Client - TOA" or "Pats Client" ... Return "Yes", if not, Return "no"

Any idea on my formula issue? I think it lies in the bolded area.

Thanks!

 

[RoryA]

You've got too many ORs in there:

ActiveCell.FormulaR1C1 = _
"=IFERROR(IF(OR(RC[-1]=""Active Client - TOA"",RC[-1]=""Past Client""),""Yes"",""No""),""No"")"

or you can use:

ActiveCell.FormulaR1C1 = _
"=IFERROR(IF(OR(RC[-1]={""Active Client - TOA"",""Past Client""}),""Yes"",""No""),""No"")"