CELL

Returns a cell of a range.

Syntax

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

  • 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