# 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="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-1a111854fa10cea50046704ffa5986891fe3dddf%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>