CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulasyntax-error
user3577904
user3577904

Reputation: 491

I get Formula parse error with all formulas

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?

Upvotes: 3

Views: 5320

Answers (1)

JPV
JPV

Reputation: 27262

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?

Upvotes: 15

Related Questions