What is the use of CELL function?

CELL Function in Excel returns information about the contents, formatting or location of a given cell

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Ultimate Project Management Template
Excel Template

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


What is the syntax of CELL function?

CELL Function in Excel- Syntax

CELL( info_type, reference )

info_type: Information to be returned
reference: Cell to be checked for information

CELL Function in Excel – Examples

CELL Function in Excel- Example 1

Example 1: returns address of the cell
Example 2: returns column number of the cell
Example 3: returns row number of the cell
Example 4: returns column width of the cell
Example 5: returns format of the cell
Example 6: returns format of the cell

info types of CELL function?

“address” returns the cell reference
“col” returns column number of the cell
“row” returns row number of the cell
“width” returns column width of the cell
“color” returns 1 if the cell is formatted in color for negative values, otherwise returns 0
“contents returns the value of the cell
“filename” returns the full path and filename of the workbook and worksheet of the cell, returns “” (blank) if the workbook has not yet been saved
“parentheses” returns 1 if the cell is formatted with parentheses for positive or all values; returns 0 otherwise
“prefix” returns a text value corresponding to the ‘label prefix’ of the cell
“protect” returns 1 if the cell is locked, otherwise returns 0
“format” returns a text value representing the formatting style of the cell


Frequently Used Excel Formats

“G”

“-”

“()”

General Format or # ?/? or # ??/??

indicates cell is formatted in color for negative values

indicates cell is formatted with parentheses for positive or all values

“F0” 0 “D1” d-mmm-yy or dd-mmm-yy
“,0” #,##0 “D2” d-mmm or dd-mmm
“F2” 0 “D3” mmm-yy
“,2” #,##0.00 “D4” m/d/yy or mm/dd/yy or m/d/yy h:mm
“C0” Currency Format (no decimal places) “D5” mm/dd
“C2” Currency Format (2 decimal places) “D6” h:mm:ss AM/PM
“P0” 0% “D7” h:mm AM/PM
“P2” 0.00% “D8” h:mm:ss
“S2” 0.00E+00 “D9” h:mm

Reference:

Please refer the below article for more Information Excel functions.
Information Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template

 
Related Resource External VBA Reference