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

CELL function

Description

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.

Example

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