PurposeGet information about a cell Show Usage notesUse the CELL function to return a wide range of information about a reference. The type of information returned is given asinfo_type, which must be enclosed in double quotes (""). CELL can return a cell's address, the filename and path for a workbook, and information about the formatting used in the cell. See below for a full list of info types and format codes. The CELL function takes two arguments: info_type and reference. Info_type is a text string that indicates the type of information requested. See the table below for a full list of info types. Reference is a cell reference. Reference is typically a single cell. If reference refers to more than one cell, CELL returns information about the first cell in reference. For certain kinds of information (like filename) the cell address used for reference is optional and can be omitted. However, if reference is not supplied, CELL will return the name of the current "active sheet" which may or may not be the sheet where the formula exists, and might even be in a different workbook. To avoid confusion, use A1 for reference. Note: the CELL function is a volatile function and may cause performance issues in large or complex worksheets. ExamplesFor example, to get the column number for C10:
To get the address of A1 as text:
To get the full path and workbook name for the current worksheet:
CELL can also return format code information. For example, if A1 contains the number 100 with the currency number format applied, the CELL function will return "C2":
When requesting the info_type "format" or "parentheses", a set of empty parentheses "()" is appended to the format returned if the number format uses parentheses for all values or for positive values. For example, if A1 uses the custom number format (0), then:
Info typesThe following info_types can be used with the CELL function:
Format codesThe table below shows the text codes returned by CELL when "format" is used for info_type.
Notes
What is cell function in Excel?The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula: =IF(CELL("type",A1)="v",A1*2,0)
When a formula includes a cell reference Excel interprets that cell reference as being located?When a formula includes a cell reference, Excel interprets that cell reference as being located relative to the position of the current cell. One challenge of nesting functions is to make sure that you include all of the parentheses.
What are the 5 functions in Excel?The most frequently used functions in Excel are:. AutoSum;. IF function;. LOOKUP function;. VLOOKUP function;. HLOOKUP function;. MATCH function;. CHOOSE function;. DATE function;. What are the various categories of functions available in Excel?Excel groups functions into 12 categories: Compatibility, Cube, Database, Date and Time, Engineering, Financial, Information, Logical, Lookup & Reference, Math & Trigonometry, Statistical and Text.
|