Function AI

AI() Description

The AI() function is designed for working with Artificial Intelligence (AI) directly in the Excel (LibreOffice Calc) worksheet.

As AI, this function uses the large language model Google "Gemini" and can be used in any formulas both independently and in conjunction with other standard functions.

Main Characteristics of the AI Function

Syntax:

=AI(Prompt; [Context])

Parameters:

• Prompt: The main prompt, in the form of text instructions for the AI.
• [Context]: (Optional) Additional data for the main prompt.

Example of Use

The AI() function is easy to use. You just need to specify the prompt and additional data, and Excel (Calc) will automatically return a response from the AI:

=AI(Prompt; Context)

We will get the following result:

In this example, the following values are used:

• Prompt: B1 - Main prompt ("Please extract only the items from the following data...").
• Context: B5 - Additional context ("Jonny wants a bike, remote control car, and basketball.").

Download extension

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

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