Once approach might be to switch to

.FormulaLocal
Note you would then use ; delimiter etc in your formula string as you would natively, eg:

.FormulaLocal = "IF(AND(A1=1;A2=2);""x"";""y"")"