This
is the cell and contents to test.
|
17.50%
|
||
The
cell address.
|
$D$3
|
=CELL("address",D3)
|
|
The
column number.
|
4
|
=CELL("col",D3)
|
|
The
row number.
|
3
|
=CELL("row",D3)
|
|
The
actual contents of the cell.
|
0.175
|
=CELL("contents",D3)
|
|
The
type of entry in the cell.
Shown as b for blank, l for text, v for value. |
v
|
=CELL("type",D3)
|
|
The
alignment of the cell.
Shown as ' for left, ^ for centre, " for right. Nothing is shown for numeric entries. |
=CELL("prefix",D3)
|
||
The
width of the cell.
|
12
|
=CELL("width",D3)
|
|
The
number format fo the cell.
(See the table shown below) |
P2
|
=CELL("format",D3)
|
|
Formatted
for braces ( ) on positive values.
1 for yes, 0 for no. |
0
|
=CELL("parentheses",D3)
|
|
Formatted
for coloured negatives.
1 for yes, 0 for no. |
0
|
=CELL("color",D3)
|
|
The
type of cell protection.
1 for a locked, 0 for unlocked. |
1
|
=CELL("protect",D3)
|
|
The
filename containing the cell.
|
C:\Users\VINO\Desktop\[excel_formulae1-0-0
(1).xls]CELL
|
||
=CELL("filename",D3)
|
|||
What Does It Do ?
This function examines a cell and
displays information about the contents, position and formatting.
Syntax
|
=CELL("TypeOfInfoRequired",CellToTest)
|
Formatting
|
No special formatting is needed.
|
Codes used to show the formatting of
the cell.
Numeric Format
|
Code
|
General
|
G
|
0
|
F0
|
#,##0
|
,0
|
0.00
|
F2
|
#,##0.00
|
,2
|
$#,##0_);($#,##0)
|
C0
|
$#,##0_);[Red]($#,##0)
|
C0-
|
$#,##0.00_);($#,##0.00)
|
C2
|
$#,##0.00_);[Red]($#,##0.00)
|
C2-
|
0%
|
P0
|
0.00%
|
P2
|
0.00E+00
|
S2
|
# ?/? or # ??/??
|
G
|
m/d/yy or m/d/yy h:mm or mm/dd/yy.
|
D4
|
d-mmm-yy or dd-mmm-yy
|
D1
|
d-mmm or dd-mmm
|
D2
|
mmm-yy
|
D3
|
mm/dd
|
D5
|
h:mm AM/PM
|
D7
|
h:mm:ss AM/PM
|
D6
|
h:mm
|
D9
|
h:mm:ss
|
D8
|
Example
The following example uses the
=CELL() function as part of a formula which extracts the filename.
The
name of the current file is :
|
excel_formulae1-0-0
(1).xls
|
|
=MID(CELL("filename"),FIND("[",CELL("filename"))+1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1)
|
||