AiTranslate Function

AITRANSLATE() Description

The AITRANSLATE() function is designed to translate text directly in a cell on any worksheet.

For text translation, this function uses a large language model Google "Gemini" and can be used in any formulas both independently and in conjunction with other standard functions.

You can also use the classic function GOOGLETRANSLATE(), which for text translation uses "Google Translate" website.

Key Features of the AITRANSLATE Function

Syntax:

=AITRANSLATE(Text; Language)

Parameters:

• Text: Cell with the text you want to translate into another language.
• Language: The language into which you want to translate the text.

Example of Use

Suppose you have a cell with text that you want to translate. You just need to enter the AITRANSLATE() formula, and Excel (Calc) will automatically translate the text:

=AITRANSLATE(Text; Language)

We will get the following result:

In this example, the following values are used:

• Text: A2 - cell with text for translation ("The quick brown fox jumps over the lazy dog").
• Language: B2 - translation language (French) ("French").

How Does It Work?

Simply enter the AITRANSLATE function into the appropriate cell, specifying the text to translate and the language into which you want to translate. Excel (Calc) will automatically use AI Google "Gemini" to provide an accurate and fast translation.

Download extension

You can use the function AITRANSLATE() by installing the extension YLC Utilities.

After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).