Formula Parse Error

[nhoornweg]

Can't get this to work... Copy-paste exact instructions and still get a "Formula Parse Error". See attached file. I'm using the scripts etc just as described. The add-in is authorized and seems to be working, yet I don't get a value.

What am I doing wrong?

[vladgaidar]

Same problem, help with solution

[nhoornweg]

Update: Really strange but when I open a totally new Google sheet, incl. the script etc. as per described, it works...

[JoaoPauloSouza]

Update: Really strange but when I open a totally new Google sheet, incl. the script etc. as per described, it works...

seems we have a similar root issue #77, i just created a new sheet and works like a charm.

[nhoornweg]

Update 2: Just found the issue (I think). Go to file, spreadsheet settings, generale. Under dropdown 'locale' change to United Kingdom... And poefff, the formulas work... Before I had it set to Netherlands. Once I changed to UK it worked... Don't know why. Also works when changing to United States... Didn't try other countries... Anyway, solved :)!

[EduardoJabour]

I had the same problem, but I tried booth creating a new sheet and updating 'locale' to UK/US and the error persists. Any ideas?

[JoseSolana]

Update 2: Just found the issue (I think). Go to file, spreadsheet settings, generale. Under dropdown 'locale' change to United Kingdom... And poefff, the formulas work... Before I had it set to Netherlands. Once I changed to UK it worked... Don't know why. Also works when changing to United States... Didn't try other countries... Anyway, solved :)!

It works for me.

Thank you very much!

[l4r53n]

Make sure the option "Always use the names of the functions in English" is checked in locale settings