Overview
The VX.ANALYSIS function allows you to leverage AI directly in your Excel workbook cells. It sends a prompt to Velixo Intelligence along with optional Excel range context, and returns the response as text or a spilled array.
Use it to summarize financial data, generate commentary, extract structured information from unstructured text, or answer questions about data in your workbook.
The function requires at least one active ERP connection.
VX.ANALYSIS does not support the multiple connection functionality.
Syntax
=VX.ANALYSIS(
Prompt,
Settings,
ContextOrAdditionalPrompt,
...
)
Arguments
|
Argument |
Required / Optional |
Description |
|---|---|---|
|
|
Required |
Text that describes the task or question for Velixo Intelligence. |
|
|
Optional |
A two-column Excel range containing advanced settings. You can use the VX.SETTINGS function to construct this array. Supported settings:
Accepted values: Default value: You can also provide a custom max character count. |
|
|
Optional |
A reference to an Excel range containing data to use as context for the request, or an additional text string to extend the prompt. You can provide multiple context/prompt arguments — they are processed together in a single request. |
|
|
Optional |
|
Output
The function returns an AI response in the source cell. Depending on the prompt, the output can be a single text string (e.g., a summary paragraph) or a multi-cell dynamic array (e.g., a table with extracted data).
The function operates only on the data you provide in the context arguments and Velixo Intelligence's general knowledge. It does not access Excel data outside the ranges you provide.
Examples
Summarize operating expenses
=VX.ANALYSIS(
"Provide a summary of the operating expenses section, highlighting the biggest drivers. Answer in one paragraph only.",
,
C11:G31
)
Description: Passes a P&L operating expenses range (C11:G31) and asks VI to summarize it in a single paragraph, highlighting the biggest cost drivers.
Extract structured data into a table
=VX.ANALYSIS(
"This is my list of projects. Extract the project type and number of hours, returning a table with two columns",
,
H2:H999
)
Description: Points VI at a free-text project list and asks it to extract structured columns. The function spills a dynamic array with the requested columns.
Control response length with Settings
=VX.ANALYSIS(
"Summarize the key takeaways from this data.",
A1,
B2:F50
)
Description: Uses the VX.SETTINGS function in A1 (=VX.SETTINGS("detailLevel", "long")) to set detailLevel to long, allowing VI to return a response up to ~5096 characters. Without this setting, the default short detail level (~512 characters) is used.
Multiple context ranges
=VX.ANALYSIS(
"Compare revenue trends across regions.",
,
"North America revenue:", B2:B13,
"Europe revenue:", C2:C13,
"APAC revenue:", D2:D13
)
Description: Passes three separate data ranges, each labeled with a descriptive prompt fragment. All context and prompt parts are processed together in a single VI request.