Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

CELL function


CELL(row,column[,raw]) returns the value of the cell with coordinates row and column.

If the column is identified by means of its alphabetic identifier (and not by a number) the identifier must be placed inside quotation marks.

Row and column numbers are zero-based. The first column is column 0, the first row (which contains the column headers) is row number 0.

If the optional 3rd parameter raw is TRUE, then the raw content of the cell (e.g. a formula) is returned as text.


When cell A5 contains 5*6, then

  • CELL(5,"A") returns the value 30.
  • CELL(5,"A",TRUE) returns the text 5*6.

Related functions