AI Function

AI() Description

The AI() function is designed for working with artificial intelligence (AI) directly in the spreadsheet Excel (LibreOffice Calc).

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

Key Features of the AI Function

Syntax:

=AI(Prompt; [Context])

Parameters:

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

Example Usage

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

=AI(Prompt; Context)

We will have the following result:

The following values are used in this example:

• 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, this function will be available in all files that will be opened in Excel (LibreOffice Calc).