4 ms·
Excel formulas have a horrible 1970:ish syntax. Reminds me of BASIC programming. But typically I get the job done, sometimes after several awkward intermediate
by usr1106 4y ago
Excel formulas have a horrible 1970:ish syntax. Reminds me of BASIC programming. But typically I get the job done, sometimes after several awkward intermediate steps.
I wasn't aware that Google has a different one. I have never used more than simple sums and differences in Google sheets. Can you give an example where Google offers better, incompatible functionality?
- m-p-3 4y agoFor example, QUERY [1], SPLIT [2] and ARRAYFORMULA [3] are the ones that comes to mind. To be fair MS Excel can do arrayformulas, but I prefer GSheet's syntax. Last time I tried Excel, TRANSPOSE wasn't a thing it but it seems to be there now. [1]: https://support.google.com/docs/answer/3093343 https://support.google.com/docs/answer/3093343 [2]: https://support.google.com/docs/answer/3094136 https://support.google.com/docs/answer/3094136 [3]: https://support.google.com/docs/answer/3093275 https://support.google.com/docs/answer/3093275