The formula editor has one big advantage to MS Office: You don't have to do dozens of mouse-clicks to create a formula, so you are much faster.
I agree that it needs getting used to, but that's no problem if you spend three minutes reading the documentation.