Google Sheets- Formula parse error with all formulas

3
votes

I want to use basic functions in google spredsheets (which works just fine in excel) but I get "Formula parse error" on all of them.

For example, there is table where date is in one column, and according value in second. I want to extract, into another sheet, value from the 1st week to the first row, value from the week +1 to second etc....

=OFFSET(A2, 1, 0)
=OFFSET(A2, 1, 0, 1, 1)

I get Parse formula error. It is happenning also with other formulas, LEFT, CONCATENATE etc... Is there anything wrong in the way I write them?

Thank you!

1
google-sheets

1 Answers

12
votes

This might be a locale issue. Some locales use a comma as argument separators, others (e.g. some European countries) use semi-colons (;). So maybe try changing your comma's into semi-colons?