Excel to Google Sheets – Error: Formula parse error
There is nothing wrong with the formula in the example. The problem is that it is referring (directly or otherwise) to cells that themselves contain formulae that Google Sheets does not recognise – in particular those containing square brackets.