# 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)
```