Articles with the tag:

How to switch between two languages in a table?


The Spreadsheet Editor allows you to change the language of the table on-the-go by using the IF function together with the Integration parameter. To do that, insert the function with the parameter and the arguments described below to create a legend for an easy language change and to arrange for the change in the necessary cells.

The following guide is based on the English-German language pair.

This guide does not cover the specifics of the IF function. For more information on the function, please visit the IF function page.

Creating a legend: the IF function + the Integration parameter

  1. Decide on a cell for a changeable numeric value (“1” or “2”) of the Integration parameter (in our case, it is C3) since the language change is based on this value.
  2. Click on a cell for displaying the future legend (in our case, it is B3) and type in the IF function with the Integration parameter in the cell chosen for the future legend:


    language change language change
  3. Make sure to rename the current sheet as "Integration" to use the formulas given in the examples of this guide or insert the name of your current sheet instead of "Integration" in each formula used in this step and henceforth.

  4. Click on a cell for displaying the tip on the language change (in our case, it is D3) and type in another IF function:

    =IF(Integration!C3=1,"Change the document language: 1-English, 2-German", "Ändern Sie die Sprache des Dokuments: 1-Englisch, 2-Deutsch")

    if function if function

Connecting the cells to the legend

To connect the cells to the IF functions described above, insert a similar IF function into each cell that is required to change its language:

  1. Click on a cell with a text value required to change.
  2. Type in the following function:

    =IF(Integration!C3=1,"Text value in English","Textwert auf Deutsch")

    Enter your values for the TRUE and FALSE arguments for the IF function and the cell address of the Integration parameter (in our case, it is C3). For example,
    change cell_if change cell_if
  3. Repeat steps 1 and 2 until your table is completed.

Changing the language

To change the language of the document, type in the necessary numeric value in the cell defining the Integration parameter. In our case, it is C3:

  • “1” is for English:
    english result english result
  • and “2” is for German:
    german result german result
Try now for free Try and make your decision No need to install anything
to see all the features in action
You Might Also Like This: