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


easy vlookup stepsvba check boxexcel vba break for loopexcel nested if and statementsword userformexcel vba tipsexcel 2007 add chart titleexcel vba paste rangeexcel vlookup formulalock worksheet exceldatabase dmlif not blank in excelexcel table remove duplicatesxls vlookup exampleexcel if statements examplespivot table wizard excel 2013open protected excel workbook without passwordproject charter ppt presentationit fresher interview questions and answershow do i get rid of extra pages in excelmonthly task planner templateexcel formula substituteexcel vlookup sampleapplication screenupdating trueexcel vba array functionsexcel trim commandvb6 color codesdownload data mining add in for excel 2013ms access vba tutorial pdfhow to unprotect excel sheet without password freeexcel macro formvba static arrayexcel vba comboboxexcel vertical lookuphow to create a worksheet in excel 2007hlookup formula in excel 2010excel count duplicates in columnexcel vba combobox additemoutlook vba code samplesfso opentextfilevb open file dialogvba if statement exampleresource planning spreadsheet templatedcl languagehow do you unprotect an excel spreadsheetvba reference guidevba database objectunlock vba project passwordexcel if not blankexcel vba range objecthow do you do a tick on excellookup function excel 2010vba servervba activesheethow to use sumif functionuserform in vbahow do i merge cells in excelhow to delete empty cells in excelexcel project trackerms excel unhide rowshide column vbacool vb scriptsdml dclvba excel code examplesfaq testing interview questions answersxldown vbahow to edit hyperlink in excelexcel remove duplicate entriesinstr vbaformat vba codeproject charter ppt presentationcreate sheet vbahow to eliminate blank rows in excelhow do you create a filesystemobjectonline unprotect excel sheet