> For the complete documentation index, see [llms.txt](https://docs.kognitos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/excel-v2/get-a-cell-value/get-a-cells-formula.md).

# Get a Cell's Formula

Gets the formula from a specified cell in a worksheet.

### Overview

This procedure finds and retrieves the formula from a specific cell in an Excel worksheet. If the cell does not contain a formula, it returns "No formula." This is useful in automation workflows that need to access and interpret formulas.

### Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

<details>

<summary><code>get the cell's formula</code></summary>

#### What does it do?

Retrieves the formula from the current cell.

#### Where does it go?

This phrase should be written on a **new line**.

#### Is it required?

✅ Yes — This phrase is **required**.

#### Does it require data?

✅ Yes — A reference to **the cell** must be defined in the automation.

</details>

### Examples

#### 1. Get Cell's Formula

Retrieves the formula from a specific cell.

```
get the worksheet's cell where
    the cell reference is "C1"
get the cell's formula
```