REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

What is the use of CELL function?

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

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

Effortlessly Manage Your Projects and Resources
120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Categories: Excel FormulasTags: Last Updated: June 17, 2022

Leave A Comment