# GPT Formula Reference

{% hint style="info" %}
Each of these formulas are demonstrated in our public template. [Arcwise - Public Template](https://docs.google.com/spreadsheets/d/15QAnr4uISOVpHHkfT8z1B_d2IOdUaw3r-eeP33da-JA/copy?usp=sharing)
{% endhint %}

### Model usage

All Arcwise AI functions use the [OpenAI gpt-4o](https://openai.com/index/hello-gpt-4o/) models through Microsoft Azure. We take data privacy and security seriously: both our [privacy policy](https://arcwise.app/notices/privacy) and [Azure's privacy policies](https://learn.microsoft.com/en-us/legal/cognitive-services/openai/data-privacy) guarantee that your data will never be sold or used for model training purposes.

For a limited time only, usage of AI formulas **is completely free**. (This will likely change at some point in the future!)

### AI.TRANSFORM

Transforms a target value based on a prompt.

**Examples**

```excel-formula
AI.TRANSFORM("Moby Dick", "write a short summary")
AI.TRANSFORM(A1, "write a short summary")
AI.TRANSFORM(A1, A2)
```

**Syntax**

```excel-formula
AI.TRANSFORM(VALUE_TO_BE_TRANSFORMED, PROMPT)
```

### AI.CLASSIFY

Classifies a value based on a list of categories. The list of categories can come from a range of cells.

**Examples**

```excel-formula
AI.CLASSIFY("Moby Dick", "novel, article, snoozefest")
AI.CLASSIFY("Moby Dick", $A$1:$A$3)
AI.CLASSIFY(B1, $A$1:$A$3)
```

**Syntax**

```excel-formula
AI.CLASSIFY(VALUE_TO_BE_CLASSIFIED, categories, [descriptions])
```

`categories` can be a comma separated list of values or a range of cells.

Optionally, you can also provide a range of `descriptions` to provide more information about each category. For example, if you had a table of customer support tickets, you could define a table of ticket categories and descriptions in a `categories` sheet:

<table><thead><tr><th width="71" data-type="number"> </th><th width="231">A</th><th>B</th></tr></thead><tbody><tr><td>1</td><td>Return request</td><td>If the customer is trying to return an item</td></tr><tr><td>2</td><td>Billing issue</td><td>If there's an issue with the payment method</td></tr><tr><td>3</td><td>Quality issue</td><td>If there's an issue with the delivered product</td></tr></tbody></table>

This formula would then categorize A1 based on both the categories and the descriptions:

```excel-formula
AI.CLASSIFY(A1, categories!$A$1:$A$3, categories!$B$1:$B$3)
```

### AI.EXTRACT

Extracts a fact or data point from the input. For example, part of an address, or a person's name from an email, etc.

**Examples**

```excel-formula
AI.EXTRACT("123 Main St. Jersey City, NJ 07302", "state")
AI.EXTRACT(A1, "state")
AI.EXTRACT(A1, B1)
```

**Syntax**

```excel-formula
AI.EXTRACT(VALUE_TO_EXTRACT_FROM, ITEM_TO_BE_EXTRACTED)
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.arcwise.app/using-arcwise-ai-formulas/gpt-formula-reference.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.