YES, you can, just use FormulaLocal. 😉

Exemple in French version, both are working the same way.

Sub test()
    Cells(1, 1).Formula = "=RIGHT(""TOTO"", 2)"
    Cells(1, 2).FormulaLocal = "=DROITE(""TOTO""; 2)"
End Sub