> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/cell.md).

# CELL

#### Syntax <a href="#syntax.5" id="syntax.5"></a>

**CELL**(*range*; *rowIndex*; *columnIndex*)

* *range* - a range of values - ***Value type**: range*
* *rowIndex* - the index of the row of the cell to return - ***Value type**: integer (optional, default value: 1)*
* *columnIndex* - the index of the column of the cell to return - ***Value type**: integer (optional, default value: 1)*

#### Remarks <a href="#remarks.3" id="remarks.3"></a>

* The function can either be called with 1 or 3 parameters.
* *rowIndex* and/or *columnIndex* can contain the text “last”. In this case, the last row or the last column of *range* is used as index.

#### Example

<figure><img src="/files/zc3zcQy9C9PJDUBmim8D" alt=""><figcaption></figcaption></figure>