CELL Function in Excel

Home/Excel Formulas/CELL Function in Excel

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

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


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
By |April 14th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment


Related pages


countif syntaxvba msgbox custom buttonsexcel vba unselectunprotect password protected excelbreak statement in vbaexcel 2007 calendar templateprotect password excelmake drop down list in excel 2007excel vba combobox rowsourceexamples of vlookupsimple vbscript examplevba code excelspotfire basicssql update from excelunlock macrohow to eliminate rows in excelhide rowsexcel surface charttick on excel spreadsheethow to use a sumif formuladdl and dml commandsexcel vba select rowsshortcut key to delete sheet in excelvba excel sheetunprotect an excel workbook without passwordexcel vba data typesremove duplicates vbapassword protection excel 2010vba dynamic rangevba function excelmerge macro excelvba application.runexcel vba range variablesimple vba programmicrosoft excel sumif functionvba msofiledialogfilepickersql vba accessx1up vbashortcut for delete in excelvba adodb referenceexcel merge tabsvba close workbookinsert tick box in excelvba code to open excel filecounting duplicate values in excelsave excel to xmlvba excel isnumberbar chart excel templateoffset meaning in hindihow to remove password from protected excel sheet 2007how to protect sheets in excelexcel chart sampleswhat is a vlookup function in excelvba select caseexcel vba sumifdelete blanksvba entire row deletevba function tutorialsql quiz for interviewvba byvalexcel dashboard torrentcheckbox in excel vbadashboards in excelexcel remove workbook protectionsave xlsm as xlsxediting macros in excelchecklist template excel 2007excel ascending ordervba open hyperlinkexcel linked cellsconsolidate in excelexcel 2007 autosave locationcol index num in vlookupsql codes examplesmysql ole db provider downloadchart wizard excel 2013create folder vbainsert checkbox in powerpoint 2010