How to Change a Non Regional Google Sheets Formula

0
102
How to Change a Non Regional Google Sheets Formula

If you are from a different region other than mine for example form UK or Russia, when you copy a formula from any of my Google Sheets tutorials it may not work for you. You should make some changes to the formula. So here we can learn how to change a non regional Google Sheets Formula to your Locale.

Google Sheets is surely the fastest growing spreadsheet applications. It has lots of advantages like its own unique functions and other features. So, surely there is no doubt, once started using users will realise the potential of Google Doc Spreadsheet.

As you know, Google Sheets is an online Spreadsheet applications. You can use Google Sheets in your regional language. As of now, the functions in Google Sheets are available in 22 different languages.

How Google Sheets’ Language and Locale Settings Affect Functions

There are two important settings that affect the formula in Google Sheets. One is Language and the other is Locale. The former, as the name depicts, is related to the language and the latter is related to date, currency and number formatting. You can see this Doc’s Support article to see the instructions to change those settings.

When you get access to a shared Google Sheets from a different Locale, you can see that the formula has some changes. You can of course make a copy of the sheet, if the sharing settings allows, and can use the sheet without any issue. Because the sheets Locale is still the same. That means the existing formulas would work without any issue. But when you key in any new formula as per your locale, it may not work.

How to Change a Non Regional Google Sheets Formula and Escape Formula Parse Errors.

There are two options. If you plan to use the existing sheet, you can easily change the locale from the file menu Spreadsheet settings. Just change the locale and time zone to yours and the formula would also reflect the changes.

Now when you copy a formula from a non regional Google Sheets to your’s, you should make some changes to the formula. Mainly you should change the argument separators as follows.

1. A semicolon should be replaced by a comma or vice versa.

2. A back slash in an Array should be replaced either by a comma or semicolon depending the desired array output.

={1\ 2} to ={1, 2} or ={1; 2}

The above changes is relevant because in some countries comma is normally used as decimal separators (for example €6,00). Keep remember this when you change a non regional Google Sheets Formula to your locale.

LEAVE A REPLY

Please enter your comment!
Please enter your name here